"Peo Sjoblom" wrote in message
...
Are you sure it's zero, copy it to another call and paste special as
values
and see what you get, byw how does your custom format look like copied
from
the format windowscustom?

--

Regards,

Peo Sjoblom
You're absolutely right, it's not zero, I have cents in there. The cells
are formatted to 0 decimals - so even though the sum is 0, Excel gives me
(0) because of the hidden decimals. How do I get cells where the decimal
value is -0.50 to display as "-"?