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?

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.

"Janice" wrote:

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?

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

"Janice" wrote in message
...
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?