View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
J Slocum J Slocum is offline
external usenet poster
 
Posts: 1
Default How do you enter zip codes starting with 0 for a mail merge

I have an address list created in Excel which I'm trying to export into a
mail merge in Word. Most of my zip codes begin with a "0" and although I'm
putting an apostrophe before the zero it doesn't carry over into the mail
merge so I'm coming up with a 4 number zip code instead of a full zip code.
I've tried setting the format as text and as special/zip code. I was been
able to make it work in one worksheet a long time ago but now it doesn't work
in the others - what am I missing???
Anyone willing to help?