View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MsShagas
 
Posts: n/a
Default losing zeros on zip codes when I create mail merge

Thank you for your quick reply. Could you please elaborate on set up of "string
variable" - I did format the cells to Special - Zip Code.

"Fred from NYC" wrote:

Is the ZIP code set up as a string variable in Excel?

MsShagas wrote:
When I merge excel list to Word I lose the first zero of zip code - comes in
as 8401 instead of 08401. How do I correct? Thank you.