ZIP codes beginning with 0

[Peter]

I'm having trouble getting ZIP codes beginning with 0 to
stick, even when specifying ZIP code in the format
category type. No matter what I do, the initial 0 always
gets dropped.

Advice? Thanks.

 

[CLR]

Hi Peter..........

Either pre-format your cells as TEXT, or enter a leading apostrophe before
entering the number with the leading 0........the apostrophe won't show, it
only forces TEXT formatting on that cell..........

Vaya con Dios,]
Chuck, CABGx3

 

[David McRitchie]

You will not have the trouble with proper zip+4 zip codes because they
are text. To fix your existing zip codes with 1st digit dropped, format
the column as Text and then run the macro FixUSzip5 at
http://www.mvps.org/dmcritchie/excel/join.htm#fixuszip5

Hi Peter..........

Either pre-format your cells as TEXT, or enter a leading apostrophe before
entering the number with the leading 0........the apostrophe won't show, it
only forces TEXT formatting on that cell..........

Vaya con Dios,]
Chuck, CABGx3

I'm having trouble getting ZIP codes beginning with 0 to
stick, even when specifying ZIP code in the format
category type. No matter what I do, the initial 0 always
gets dropped.

Advice? Thanks.