[PA Bear]

Forwarded to microsoft.public.word.mailmerge.fields via cross-post.
--
~Robear Dyer (PA Bear)
MS MVP-Windows (IE/OE, Shell/User, Security), Aumha.org VSOP, DTS-L.org

IrishMike wrote:
I'm using Mail Merge to create labels for a Mailing list.
In most of the lists the City, State and Zip are in one field, and they
work fine and the labels are good.
In one list it's necessary to have the Zip in a separate field and the
problem here is that the Zip comes out with a period and zero after it.
Eg if the correct zip is 11145 the zip coming up in preview and on the
printed label is 11145.0
I have tried various formatting options and its still the same, and I have
found that any cell containing only numbers comes out the same, eg Social
Security numbers, telephone numbers etc. Even formatting the cells as
text, once only numbers are present, the problem is still there. Any
ideas on how to correct. Thanks. Mike