Zip codes become "0" folloing a merge

[Russ]

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
(e-mail address removed)

 

[Doug Robbins - Word MVP]

Hi Russ,

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

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


--
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