Zip codes become "0" folloing a merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russ - 07 Apr 2004 01:59 GMT

92129-1234 in an Excel DB becomes "0" when merged in Word.
How can I prevent this?

2nd - If I simply delete the last 4 and the dash "0" still
appears. The only way to get a zip code to show is to copy
the contents of another cell with the desired zip code in
it. If I copy another Zip code in just to get the
formatting, then change it tot the zip I want, the zip
still shows up as "0".

Any Ideas Why or how to correct the problem???

Thanks, Russ
Rusf2000@Yahoo.com

Reply to this Message

Doug Robbins - Word MVP - 07 Apr 2004 05:13 GMT

Hi Russ,

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

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

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> 92129-1234 in an Excel DB becomes "0" when merged in Word.
> How can I prevent this?
[quoted text clipped - 10 lines]
> Thanks, Russ
> Rusf2000@Yahoo.com

Reply to this Message