Zip Codes not transferring correctly to merge document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shannon - 15 Aug 2005 14:25 GMT

RUSH!!!!!

I have formatted the post code column in my excel worksheet to show the
following format, ex: 12345-1234 & 01234.

When I merge this file to my word mail merge document the format changes to
this... 123451234, 1234, & 0.

What happened to my dashes and zero before my zip code? Also why would the
zip code completely change to 0???

Reply to this Message

Doug Robbins - 15 Aug 2005 15:19 GMT

See "Formatting Word fields with
switches" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> RUSH!!!!!
>
[quoted text clipped - 8 lines]
> the
> zip code completely change to 0???

Reply to this Message