Excel 2007 automatically corrupts my data!!

  • Thread starter Thread starter Valerie
  • Start date Start date
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!
 
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 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Excel Excel 2007 won't stop rounding down my formula results! 5
automatic time formatting 3
Excel automatically changes numbers like1989to19.89 why? Help! 1
Stop XL from changing format? 1
I cannot enter a number containing more than 15 digits in Excel 1
Need a formula for a descimal integer into a whole number 1
Stop Excel 2007 from Changing Column Widths 4

Back
Top