P
PMBO
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 
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 