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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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
 
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.
 
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.
 
Back
Top