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 |
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 |
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 |
All times are GMT +1. The time now is 10:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com