Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 automatically corrupts my data!!
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 "Valerie" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 - automatically changes text data to numbers | Excel Discussion (Misc queries) | |||
GIF image on web-page corrupts data fetched with Web Query | Excel Discussion (Misc queries) | |||
Sort corrupts mass data intermittently? | Excel Discussion (Misc queries) | |||
Attaching to an email corrupts workbook | Excel Discussion (Misc queries) | |||
Excel Virus - Corrupts Default Options (Excel 2000) | Excel Discussion (Misc queries) |