[bh]

In Version 2003, for a mailmerge using data in Excel, how does one format the
cells for the Zip Codes so that the Zip Code numbers starting with 0 will
appear in the word merge. For example, the Zip Code for Englewood, NJ is
07631, and if the Zip Code cells are formatted as Number, Special, General,
or even programmed in Custom, the first digit "0" does not appear in the
merge, but the only the "7631" appears. On the other hand, if the Zip Code
cells are formatted as Text, only the first digit "0" appears in the merge,
but not the remaining digits of the Zip Code.

[Peter Jamieson]

Use Alt-F9 to reveal the underlying field codes, e.g.

{ MERGEFIELD myzipcode }

strip out anything that looks like \*mergeformat

and change the code to

{ MERGEFIELD myzipcode \#00000 }

Peter Jamieson

http://tips.pjmsn.me.uk

BH wrote:
In Version 2003, for a mailmerge using data in Excel, how does one format the
cells for the Zip Codes so that the Zip Code numbers starting with 0 will
appear in the word merge. For example, the Zip Code for Englewood, NJ is
07631, and if the Zip Code cells are formatted as Number, Special, General,
or even programmed in Custom, the first digit "0" does not appear in the
merge, but the only the "7631" appears. On the other hand, if the Zip Code
cells are formatted as Text, only the first digit "0" appears in the merge,
but not the remaining digits of the Zip Code.

[bh]

Thanks. This didn't work for me, but another post in the Excel Discussion
Group explained how to open via DDE.

Use Alt-F9 to reveal the underlying field codes, e.g.

{ MERGEFIELD myzipcode }

strip out anything that looks like \*mergeformat

and change the code to

{ MERGEFIELD myzipcode \#00000 }

Peter Jamieson

http://tips.pjmsn.me.uk

BH wrote:
In Version 2003, for a mailmerge using data in Excel, how does one format the
cells for the Zip Codes so that the Zip Code numbers starting with 0 will
appear in the word merge. For example, the Zip Code for Englewood, NJ is
07631, and if the Zip Code cells are formatted as Number, Special, General,
or even programmed in Custom, the first digit "0" does not appear in the
merge, but the only the "7631" appears. On the other hand, if the Zip Code
cells are formatted as Text, only the first digit "0" appears in the merge,
but not the remaining digits of the Zip Code.