Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excell change my last number to "0" in a string?
In MSExcell 2002 SP3. In a cell I enter a string of numbers, ie..1658618353,
then when I leave that cell or hit "enter" the last number chages to "0" ie... 1658618350. I have tried reformatting the cell, deleting the info and re-entering it, and everything I could find in "help". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excell change my last number to "0" in a string?
Is that your credit card number ? Thank you.. :)
Seriously, excel has 15 digit precision and anything more than that will be truncated to a zero, if you need to store numbers greater than 15 digits preformat cell(s) as text or precede the entry with an apostrophe ' -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "dlooney2006" wrote in message ... In MSExcell 2002 SP3. In a cell I enter a string of numbers, ie..1658618353, then when I leave that cell or hit "enter" the last number chages to "0" ie... 1658618350. I have tried reformatting the cell, deleting the info and re-entering it, and everything I could find in "help". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Change cell color if it is the lowest number of a group? | Excel Discussion (Misc queries) | |||
Change number when you open the excel template | Excel Discussion (Misc queries) | |||
adding a number to every change in value | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |