zip codes in Excel

[Doug Tenney]

I am keping a database of 500 plus. I want to enter zip codes in Vermont
that start in zero or 0, but excel is dropping the zero and I get a value
with only 4 numbers. So a zip code of "01234" only shows up as 1234

How do I get the 0 to show up as the first digit, what do I need to change?

Thanks again!!

--

========================

Doug Tenney

4872 Royalton Road SW
Lancaster, Ohio 43130-9546

(e-mail address removed)

740.681.1690

fax to 740.474.6419

 

[Peo Sjoblom]

Format custom as 00000

 

[Rune_Daub]

or you could just format the zip code fields to text format.
Its not like you will be doing any calculating on the areas anyways :

 

[RagDyer]

Are you aware of the fact that XL has a "Special" format already created for
zip codes, both regular and the +4 type ?

<Format> <Cells> <Number> tab,
And click on "Special" in the Category window.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am keping a database of 500 plus. I want to enter zip codes in Vermont
that start in zero or 0, but excel is dropping the zero and I get a value
with only 4 numbers. So a zip code of "01234" only shows up as 1234

How do I get the 0 to show up as the first digit, what do I need to change?

Thanks again!!

--

========================

Doug Tenney

4872 Royalton Road SW
Lancaster, Ohio 43130-9546

(e-mail address removed)

740.681.1690

fax to 740.474.6419