Zip codes in mail merge - first digit doesn't display in merge

[Cheryl]

Office 2007 - used spreadsheet to create an address list; zip codes appear
correctly in spreadsheet but when using spreadsheet as a mail merge document,
the first digit disappears in the zip code field, i.e., 05401 becomes 5401.

 

[David Biddulph]

=text(a1,"00000")

or use Word field formatting codes:
Mail merge Excel to Word:
a.. http://www.mvps.org/dmcritchie/excel/mailmerg.htm
b.. http://www.mvps.org/word/FAQs/MailMerge
c.. http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx
d.. http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm
e..