mail merge in excel/losing leading zero

[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!

 

[Bruce Sinclair]

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!

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