mail merge in excel/losing leading zero

  • Thread starter Thread starter Stacie
  • Start date Start date
S

Stacie

I have tried formatting the cell as text and adding an apostrophe before the
leading zero in my zip code but when I do that now only the 0 shows up on my
mail merge document (I lose the rest of the zip code). HELP!
 
I have tried formatting the cell as text and adding an apostrophe before the
leading zero in my zip code but when I do that now only the 0 shows up on my
mail merge document (I lose the rest of the zip code). HELP!
Click to expand...

Are you using the DDE option to get your data from XL ? Other options seem
to do odd things to the format in word. Not sure if this is your problem,
but it's worth trying if you are using something else :)
 
Back
Top