| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Peculiar Result with SUM
I have 7 rows of data in one column, the SUM of which adds up to Zero,
as expected, except it doesn't. In the SUM cell formatting to 13 decimal place shows as 0000etc13. I've even retyped the 7 rows of data (max of 2 decimal places) and my result is still the same. I even pasted-special values ROUND after that and same result How can that be? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very Peculiar DV error Q | Excel Worksheet Functions | |||
| Peculiar Date problem | New Users to Excel | |||
| Peculiar date format behavior when replacing parts of date | Excel Discussion (Misc queries) | |||
| How to do a peculiar sort? | New Users to Excel | |||
| A peculiar PDF from Excel problem | Excel Discussion (Misc queries) | |||
Threaded Mode
