I just ran into an unusual issue with summing three numbers.
Cells formated as accounting, no symbol, 2 decimal. On all other sums I
have the zero values displaying as - instead of 0.00. But in this strange
case these three numbers are displaying as 0.00. When I change the decimal
places to 25 you see 'extra' numbers appear in the sum. There are no other
formulas or formating tied to these cells.
These are the values I am summing:
(606.02)
643.20
(37.18)
Sum is showing 0.00

If I change the column to 25 decimals you see:
(606.0200000000000000000000000)
643.2000000000000000000000000
(37.1800000000000000000000000
Sum is showing as 0.0000000000000639488462184
Where are these numbers coming from? No, I'm not a 'math' guru, I'm
actually helping the company controller solve the mystery.

I know its not the formating since currency or number have no effect and
putting other values in the same cells don't have the issue. Only this
particular combination of numbers being summed.

Can anyone clue a non-math specialist in? And in such a way I can translate
to our controller?

Thanks