Can I shut off Excel automatically removing the first 0
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
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?action=getinfo&userid=29154
View this thread:
http://www.excelforum.com/showthread.php?threadid=488737
.
Relevant Pages
- Re: Much help needed on conversion!
... manage to test out both codes and both works! ... oOpsy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29132 ... Prev by Date: ...
(microsoft.public.excel.programming) - Re: Difficult (at least to me) formula question
... codes. ... The data sheet looks like this: ... darkwood's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29948 ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions) - Re: A Question Regarding Comments
... Do you mean on the link to Debra Dalgleish's codes? ... mevetts's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29130 ... Prev by Date: ...
(microsoft.public.excel.misc) - Re: excel trying to sum a column of calculated values
... Works for me when I do it, what exactly are you entering? ... EdMac ... EdMac's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30736 ... Prev by Date: ...
(microsoft.public.excel.misc) - Data Entry
... Is there a way to automatically have a decimal place when entering ... similar to setting your calculator to automatcally put in a ... Chrisp's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6365 ... Prev by Date: ...
(microsoft.public.excel.misc) |
|
