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
Was This Article Helpful?