View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PMBO PMBO is offline
external usenet poster
 
Posts: 10
Default Calculation inconsistent

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 -