Excel 2007 automatically corrupts my data!!

V

Valerie

Hello,

I am doing something very simple. I am trying to enter a number with 16
digits into a cell. The default number format is "General". The number I want
to enter is 5693400088118619.

However, the number that appears is: 5.6934E+15

When I change the number format to number with no decimal places, the number
has changed to 5693400088118610. Notice that the last number is a 0 instead
of a 9.
How can I stop Excel from corrupting my data?

Thanks!
 
P

Peo Sjoblom

This is not unique for Excel 2007, Excel has 15 digits precision and will
truncate digits after the 15th.
Precede the entry with an apostrophe ' or format as text before you enter
these numbers.

--


Regards,


Peo Sjoblom
 

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

Excel Excel 2007 won't stop rounding down my formula results! 5
Stop XL from changing format? 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
How do I prevent the cell from changing the number I enter? 2
I cannot enter a number containing more than 15 digits in Excel 1
Number automatically divided by 100, why? 4
Entering data 1
Equations and Text in same Cell 2

Top