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

[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?

 

[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.

 

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP