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.