Lead zero suppression

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill R - 19 Feb 2004 18:02 GMT

Using an Excel file as the address data source for a mail
merge. The zip code field is formatted using zip code in
Excel, however, when it comes over in the merge the lead
zeroes are suppressed. Question is: must the zip code be
entered only as text in Excel to prevent the suppression?
Thanks for your help.

Reply to this Message

Graham Mayor - 20 Feb 2004 07:01 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Using an Excel file as the address data source for a mail
> merge. The zip code field is formatted using zip code in
> Excel, however, when it comes over in the merge the lead
> zeroes are suppressed. Question is: must the zip code be
> entered only as text in Excel to prevent the suppression?
> Thanks for your help.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 22 Feb 2004 02:17 GMT

See the item on "Formatting of Word Fields" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

Reply to this Message