zip codes

G

Gerry

I am creating a mail merge from an excel spread sheet. I
have entered zip codes i.e. 07456. I formatted the cell
using the number format for zip codes but when I use the
mail merge it shows up without the 0 (7456). I've tried
changing the format to text but it shows up as 0 not even
the other numbers. This only happens with the zip codes
starting with 0.
 
D

Doug Robbins - Word MVP

Hi Gerry,

See the "US Zip Codes" item under the "Formatting Word fields with switches"
heading at fellow MVP Graham Mayor's website at:

http://www.gmayor.dsl.pipex.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
 
Top