1st digit of zip code isn't printing if it starts with zero.

[Ask Viki!]

Word drops 1st digit of the zip code if it starts with zero. How do I fix
this?
The formatting in Excel for this column is Custom: 00000
Word 2007
Windows XP

 

[macropod]

Hi Viki,

In Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Ctrl-F9 to reveal the field coding. It should look something like {MERGEFIELD Zip};
.. edit the field so that you get {MERGEFIELD Zip \# 00000};
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.