Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 6018971032413880 That number is a big number but why is it if I try to chage the last zero to a 3 while in Excel, the zero always comes back as soon as I hit ENTER Thanks |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Look up specifications in Help and you'll find it's not an error, Excel have
15 digits of precision, everything beyond that will be truncated. Assuming you have credit card numbers or account numbers just precede any entry with an apostrophe or pre-format the cells(s) as text -- Regards, Peo Sjoblom "pcor" wrote in message ... 6018971032413880 That number is a big number but why is it if I try to chage the last zero to a 3 while in Excel, the zero always comes back as soon as I hit ENTER Thanks |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Thanks for that important info
"Peo Sjoblom" wrote: Look up specifications in Help and you'll find it's not an error, Excel have 15 digits of precision, everything beyond that will be truncated. Assuming you have credit card numbers or account numbers just precede any entry with an apostrophe or pre-format the cells(s) as text -- Regards, Peo Sjoblom "pcor" wrote in message ... 6018971032413880 That number is a big number but why is it if I try to chage the last zero to a 3 while in Excel, the zero always comes back as soon as I hit ENTER Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 printing error: "The number must be between 10 and 400. | Excel Discussion (Misc queries) | |||
error while copying number from Notepad | Excel Discussion (Misc queries) | |||
Number Stored as text Error | Excel Worksheet Functions | |||
Counting the number of Error Types | Excel Worksheet Functions | |||
Error: Number of query values and destination fields are not the s | Excel Worksheet Functions |