You will need to change the format of the spreadsheet to Text before you merge over the data. This will allow the 0's to merge over into our software.
In Excel:
1. Right-click on the column that has the list of numbers
2. Select Format
3. Then select General under Type: backspace out the word general and write 00000 and Ok4. Save the new file to your computer and upload the spreadsheet into Design and Print
0's Will Not Appear or Appear Incorrect in Mail Merge
Applies To
0's on zip code won't stay, Zip code has extra zero, zero, extra digit in zip code, 0's will not merge over, Excel, import data, mail merge, Google Sheets, Numbers, 0,
Was This Article Helpful?