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.

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

MsShagas wrote:
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.

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

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


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

"MsShagas" wrote in message
...
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.

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.

"Fred from NYC" wrote:

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

MsShagas wrote:
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.

Thank you for your help.

"Doug Robbins - Word MVP" wrote:

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

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


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

"MsShagas" wrote in message
...
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.