[anne]

Hi-
Can anyone help!?!?!

When I merge my excel file to Word the 5 digit zip 02601 (the format in
Excel) loses the first number and become 2601.
I hve made sure that the cell format is correct in Excel (5 digit zip) but
it still drops that first zero.

Does anyone know what I should do?

Thanks!

[Peter Jamieson]

Use Alt-F9 to show the "underlying field codes" in Word, and wehre you have

{ MERGEFIELD "zipcode field" }

change it to

{ MERGEFIELD "zipcode field" \#00000 }

(If you have

{ MERGEFIELD "zipcode field" \*Mergeformat }

change it to

{ MERGEFIELD "zipcode field" \#00000 \*Mergeformat }

Peter Jamieson

"Anne" wrote in message
...
Hi-
Can anyone help!?!?!

When I merge my excel file to Word the 5 digit zip 02601 (the format in
Excel) loses the first number and become 2601.
I hve made sure that the cell format is correct in Excel (5 digit zip) but
it still drops that first zero.

Does anyone know what I should do?

Thanks!