| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 adding a column of negative and positive number
Thanks for the reply. I have tried all those things.
I have even reentered the numbers to be certain that 4.22 is 4.220000000000 and not 4.220000001. Can it have something to do with positive and negative numbers. When I do a pivot some of the totals are "-" and some are (0.00) and some are 0.00. The "-" ones actually do add up to zero to the 20th decimal place. The others have value in the 7th decimal place even though the data has zeros after the first two decimal places all the way to 20th decimal. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding positive and negative numbers | Excel Worksheet Functions | |||
| Chart in Excel 2007- Positive & negative value columns | Excel Discussion (Misc queries) | |||
| Adding Negative and Positive Numbers | Excel Discussion (Misc queries) | |||
| Adding only the negative or positive numers in a column or row | Excel Discussion (Misc queries) | |||
| can i change a number formatted as positive to negative in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
