Why does Excel replace any digits beyond 15 with zeros?

C

Chass

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I keep Excel from dropping my numbers to 0 after 15 digits 1
If number in cell does not equal 6 digits, add zeros to the left 2
Help - Any number longer than 12 digits turns to scientific and ro 3
Why does excel replace my 16th number with a zero? 1
Excel and 15+ digit numbers 2
16 digit numbering 8
Why does Excel INT(x) behave like ROUND(x,0) for 10^14 and higher? 4
Compare 2 lists of random numbers - Excel 2007 4

Top