Decimals in Postal Code

[Tom W]

I am trying to mail merge addresses from an Exel spreadsheet on to envelopes using the mail merge function in Word. Everything works fine, but I am getting a decimal in the postal (zip) code field and I can't get rid of it. I have the cells in the column in Exel formatted as zip code and no matter if I insert those fields, or field match to address block in Word, I get the decimal and in one case where the zip is 05301 - it drops the leading zero. How do I resolve this?

 

[Graham Mayor]

Another of the idiosyncrasies of Office XP
See the Excel data section of
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>