Can I shut off Excel automatically removing the first 0

S

seingold

I am entering zip codes into Excel. some begin with the number 0 (e.g.,
04613) and excel automatically erased the first 0. How can I correct
this? Thanks.
 
S

SteveG

Change the cell formats where you are entering zip codes.

Format>Cells>Number Tab>Special>Zip Code



Cheers,

Steve
 
Top