How do i get Excel not to drop my 1st zero (02360)

[Guest]

I have been trying to type in zip codes that begin with the number 0 in the
the 1st number. How do I get it to stay in there?

 

[Guest]

Format the cells as text

Regards,

OssieMac

 

[Steve G]

I have been trying to type in zip codes that begin with the number 0 in the
the 1st number. How do I get it to stay in there?

I would go to format--cells--custom. In the rectangle below "type:"

enter 0##### - #### (do not put in the blank spaces--I am just
showiing it this way so you can read it) if you are using the full zip
code.

If you are using the 5-digit zip code, type 0#####

Then click okay. Format all cells like this that have a 5 digit zip
code or 9 digit zip code and not lose a digit if zero is the first
digit.

Steve G

 

[apj]

Ihave tried formatting the column before I start typing my zip codes and that
works great, however I have a list typed up already highlighting then
changing it to text does not work... how do I format a list I have typed
already to show the 0.

 

[Fred Smith]

The same way you format cells prior to entering data.

Right click on the cell, choose Format Cells..., enter a format of 00000.
To copy this format quickly, right click on the fill handle, drag down,
release the mouse button, and choose Fill Formatting only.

Regards,
Fred.