| 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 |
| 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) | |||
Threaded Mode
