Zip+4

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lynn - 19 Jan 2004 21:01 GMT

In Office XP - I'm merging from Excel to Word. All Zip+4 zip codes only print "0", not full zip code. Excel cells are formatted for Zip+4. Also tried formatting as Zip Code or Text.

Reply to this Message

Alison - 20 Jan 2004 02:46 GMT

See below. There is another person with this same issue and there is an answer following. It's under Zip Codes, Keith. Hope that helps.

Reply to this Message

Graham Mayor - 20 Jan 2004 11:06 GMT

> In Office XP - I'm merging from Excel to Word. All Zip+4 zip codes
> only print "0", not full zip code. Excel cells are formatted for
> Zip+4. Also tried formatting as Zip Code or Text.

See
http://www.gmayor.com/formatting_word_fields.htm
and
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
esp the section on Excel data

Signature

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

Reply to this Message