View Single Post
  #3   Report Post  
camell
 
Posts: n/a
Default

My zipcode is a little bit different then the examples on this web page. The
zipcodes in my Excel document are like this 02345-9899. I either get
00000-0000 or 0 depending on which format I use. Any other suggestions?

"Doug Robbins" wrote:

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

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



--
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
"Randy" wrote in message
news
When doing a mail merge from Excel into Word (both 2003) the zip code
suppresses the leading zeros in some zip codes and fould up the zip plus 4
codes as well. When you look at the fields format in Excel, it show to be
correct and everything looks fine until it is pulled into Word. Is this
some
sort of bug?
I've tried everything from changing the zip field to text, general, number
it doesn''t seem to make any difference
Thanks for any help you can give.
Randy