How do we get Mail Merge to recognize a leading 0 (zero) in the Z.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CM IT Terry - 13 Sep 2004 19:19 GMT

Our ZIP codes here in the Northeast start with a 0 (zero). I have the column
formatted as a ZIP code in Excel 2003, but it keeps coming over to Word 2003
as a 4 digit number, cutting off the leading zero. Help!

Reply to this Message

Doug Robbins - 14 Sep 2004 01:02 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Our ZIP codes here in the Northeast start with a 0 (zero). I have the
> column
> formatted as a ZIP code in Excel 2003, but it keeps coming over to Word
> 2003
> as a 4 digit number, cutting off the leading zero. Help!

Reply to this Message

TJ - 15 Sep 2004 09:59 GMT

Thank you very much for your help on Zip codes ignoring zero!

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 6 lines]
> > 2003
> > as a 4 digit number, cutting off the leading zero. Help!

Reply to this Message