Thread: Merge returns a zero instead of the 9 digit zip code from Excel li
View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
klema33 klema33 is offline
external usenet poster
  
Posts: 1
Default Merge returns a zero instead of the 9 digit zip code from Excel li
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?
Reply With QuoteReply With Quote