Losing zipcode when I merge!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anne - 06 Apr 2007 17:32 GMT

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!

Reply to this Message

Peter Jamieson - 06 Apr 2007 18:38 GMT

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

> Hi-
> Can anyone help!?!?!
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

Rate this thread: