losing zeros on zip codes when I create mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MsShagas - 06 Feb 2006 15:19 GMT

When I merge excel list to Word I lose the first zero of zip code - comes in
as 8401
instead of 08401. How do I correct? Thank you.

Reply to this Message

Fred from NYC - 06 Feb 2006 15:35 GMT

Is the ZIP code set up as a string variable in Excel?

> When I merge excel list to Word I lose the first zero of zip code - comes in
> as 8401 instead of 08401. How do I correct? Thank you.

Reply to this Message

MsShagas - 06 Feb 2006 16:31 GMT

Thank you for your quick reply. Could you please elaborate on set up of "string
variable" - I did format the cells to Special - Zip Code.

> Is the ZIP code set up as a string variable in Excel?
>
> > When I merge excel list to Word I lose the first zero of zip code - comes in
> > as 8401 instead of 08401. How do I correct? Thank you.

Reply to this Message

Doug Robbins - Word MVP - 06 Feb 2006 16:24 GMT

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

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When I merge excel list to Word I lose the first zero of zip code - comes
> in
> as 8401
> instead of 08401. How do I correct? Thank you.

Reply to this Message

MsShagas - 07 Feb 2006 11:11 GMT

Thank you for your help.

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 5 lines]
> > as 8401
> > instead of 08401. How do I correct? Thank you.

Reply to this Message