How to get zips beginning with 0 to merge Excel to Word label?

J

Janice

I have several zip codes beginning with 0 in an Excel file. They are
properly formatted in the cell as a zip code; however, when I merge to labels
in Word, the 0 is stripped. How can this be fixed?
 
S

SVC

In your master label file (without the merged data), hit Alt + F9 to reveal
the codes. In the field that represents the zip code, after the MERGEFIELD
information, type \# 00000. You would have something like {MERGEFIELD
"ZIP"\# 00000}. This tells Word to format the merge field as a 5-digit
number and to include leading zeros.

The best solution in the future is to format the zip codes in Excel as text.
 
Top