View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merge returns a zero instead of the 9 digit zip code from Excel li

See the Zip Code section of "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, originally posted via msnews.microsoft.com
"klema33" wrote in message
...
Excel 2003 list contained 5 digit and 9 digit zip codes and when merged
into
Word 2003 to do labels, a zero populated that field where the 9 digit code
should have been. To get it to work, I had to manually format each cell
that
contained the 9 digit zip code. I tried several different formats but
wasn't
about to retype 513 records. Is there any other way to solve this
problem?