Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel replace any digits beyond 15 with zeros?
We are using Excel to store a 16 digit code for tracking. Unfortunately when
we put in any number that is larger than 15 digits, the last digits are changed to zero. So a number like 1234567891234567 would be changed to 1234567891234560. A number like 123456789123456789 would be changed to 123456789123456000. Why would it do this and how do I stop it? Thanks Chass ct |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel replace any digits beyond 15 with zeros?
On Thu, 13 Mar 2008 10:28:04 -0700, Chass
wrote: We are using Excel to store a 16 digit code for tracking. Unfortunately when we put in any number that is larger than 15 digits, the last digits are changed to zero. So a number like 1234567891234567 would be changed to 1234567891234560. A number like 123456789123456789 would be changed to 123456789123456000. Why would it do this and how do I stop it? Thanks Chass ct Because Excel, like most other spreadsheets, conforms to IEEE specifications for 15 digit precision (see specifications in HELP). In order to enter you 16 digit tracking number, you may enter it as TEXT. You can do this either by formatting the cell as TEXT BEFORE entering the tracking number; OR by preceding the tracking number with a single quote (i.e. enter it as '1234567890123456789 --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel replace any digits beyond 15 with zeros?
Format them as text and they will show correctly.
-- -John Please rate when your question is answered to help us and others know what is helpful. "Chass" wrote: We are using Excel to store a 16 digit code for tracking. Unfortunately when we put in any number that is larger than 15 digits, the last digits are changed to zero. So a number like 1234567891234567 would be changed to 1234567891234560. A number like 123456789123456789 would be changed to 123456789123456000. Why would it do this and how do I stop it? Thanks Chass ct |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove and replace digits from a number | Excel Worksheet Functions | |||
How to replace 12 digits only of 16 digit number. | Excel Discussion (Misc queries) | |||
More than 15 digits in excel cell it turns them to zeros. Fix? | Excel Worksheet Functions | |||
Find/Replace last couple of digits on number | Excel Worksheet Functions | |||
Zero appears at the end of a string of 16 digits. Two zeros after | Excel Discussion (Misc queries) |