Lead zero suppression

[Bill R]

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.

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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

--
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