Decimals in Postal Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom W - 07 Dec 2003 07:11 GMT

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?

Reply to this Message

Graham Mayor - 07 Dec 2003 08:22 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am trying to mail merge addresses from an Excel spreadsheet on to
> envelopes using the mail merge function in Word. Everything works
[quoted text clipped - 4 lines]
> case where the zip is 05301 - it drops the leading zero. How do I
> resolve this?

Reply to this Message