| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum show difference of -0.000000000002501104298755
The spreadsheet was created from an Access query where the column is defined
as double with 2 decimil places. In Excel I expand the column to 30 decimal places and none of the values have anything but 0 past the second decimal place. Yet when I =SUM(E1:E763) I get the total of -0.000000000002501104298755. I have tried changing the format in Excel to currency, general, accounting, no change? Any ideas would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show Difference as a Percentage | Excel Worksheet Functions | |||
| Show difference between tow numbers as a + or - value. | Excel Discussion (Misc queries) | |||
| show time difference | New Users to Excel | |||
| Show % Difference between two numbers | Excel Discussion (Misc queries) | |||
| what is the formula to show the difference between two dates | Excel Discussion (Misc queries) | |||
Threaded Mode
