I have tried it with the SUM cell formatted as number to two decimals and it
worked fine - 0.00
(Excel 2003)
--
Traa Dy Liooar

Jock


"Perplexed" wrote:

The sum of these numbers should be zero (0). However, no matter what the
cell format, the following numbers add up to 3.55271E-15. Any ideas why?

0.94
-5
5
25
-25
3.06
-25
21
0