It's because your value actually is negative. It's something like -0.00002,
which Excel rounds to (0.00). Change your formula to round the result to two
decimal places.

--
Regards,
Fred


"Jose" wrote in message
...
How do I format cells in a spreadsheet to not show a zero balance as being
negative, i.e (0.00)? This does not happen in all of the cells only some?