View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
William William is offline
external usenet poster
 
Posts: 83
Default Zip code xxxxx-xxxx is merging in as a zero. Why?

I am merging the name and address from an excel file to a word doc. For
those customers who's zip code is in the xxxxx-xxxx format, the zip is
merging into the word doc as a numeric zero. I tried to change the format in
the excel file to text and general but neither option worked. Zip codes with
just the five digits merged over fine.