Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two columns of numbers that should sum exactly the same, to zero. In
Column One I have negative 50,000 and a negative 113.78 (separately). In Column Two I have negative 50113.78. The result should be the same. I'm using the accounting format with two decimal places. Column One gives me a (0.00) result and Column Two gives me a dash. I know that if I use the Set Precision as Displayed I can force them to look consistent. Can anyone explain why this is happening, please? Column One 100,113.78 (50,000.00) (50,000.00) (113.78) Total (0.00) Column Two 100,113.78 (50,000.00) - (50,113.78) Total - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inconsistent Formula? | Excel Discussion (Misc queries) | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
NETWORKDAYS calculation returns inconsistent results | Excel Worksheet Functions | |||
Inconsistent CSV export format | Excel Discussion (Misc queries) | |||
3-d referencing inconsistent | Excel Discussion (Misc queries) |