different zip codes

N

nick

I am having trouble with merging some zip codes into word
(XP) from an excel file. If its a zip code with 5
numbers, its fine. If its a zip code with a dash or zero
in front if it, it merges into word as a 0. The weird
thing is that I have been able to format the Zip Code
column in excel as text, and the worked the first time.
But it doesn't work any more. Yet for some reason, I can
set up a trial worksheet and numbers with front 0s and
dashed merge fine. How can I get it to where the zip
codes will merge no matter how many numbers or if it has
dashes.
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top