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! |
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) |