[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

[Graham Mayor]

See the relevant section at http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


PA Bear wrote:
Forwarded to microsoft.public.word.mailmerge.fields via cross-post.

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