MenusearchAvery
Account
Shopping Cart

0's Will Not Appear or Appear Incorrect in Mail Merge

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

Was This Article Helpful?