Importing Zip Codes from Excel File

[Guest]

When importing zip codes from excel for a mail merge function the leading 0 in the zip code is dropped, i.e. zip code 01234 shows up as 1234. Converting the cells/values in excel from numeric to alpha does not fix the problem.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Charlie,

See the following page of fellow MVP Graham Mayor's website:

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

 

[Guest]

What I've been doing is putting an If.Then.Else field prior to the zipcode. The field should read:
If Zip<10000 then 0 else
or
{ IF Zip<"10000" "0" ""}

If using the insert word field box, it'll be something like this:
Field code:Zip; Comparison:Less than; Compare to:10000 ;Then Insert this text:0; Otherwise insert this text:

It'll enter a zero if Zipcode is <10000 or nothing if the Zipcode is >=10000

 

[Guest]

Try: In Excel - Format, Cells, Special, and select Zip Code