View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Valerie Valerie is offline
external usenet poster
 
Posts: 79
Default Excel 2007 automatically corrupts my data!!

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!