dropped lead 0 in zip code Word 2002

K

Keith

I'm attempting a Mail Merge from an Excel 2002 spreadsheet
to Word 2002 mailing labels. Once the Mail Merge wizard
is finished all the information is there except the
leading zero is dropped from the zip code, i.e. 04869
becomes 4869. In the Excel spreadsheet the column "zip
code" is formatted as zip code. How do I get the leading
zero to appear on the mailing labels?
 
G

Greg Maxey

Keith,

I did not get a chance to test with an EXCEL merge, but
try a numberic switch in your mergefield (e.g., {
YourMergeField \# 00000 } )
 
Top