Can I shut off Excel automatically removing the first 0
 

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.


--
seingold
------------------------------------------------------------------------
seingold's Profile: http://www.excelforum.com/member.php...o&userid=29154
View this thread: http://www.excelforum.com/showthread...hreadid=488737

Can I shut off Excel automatically removing the first 0
 

Change the cell formats where you are entering zip codes.

FormatCellsNumber TabSpecialZip Code



Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=488737