Maybe your zero is not zero but some small number greater than 0. Increase
the decimal places on it and check.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Uncle Ben" wrote in message
...
Hi everyone. I have created a new custom number format that replaces 0
values with a dash (-).

But there's a problem with this. In cases where the zero value is
generated
from a formula that takes the value in one cell and subtracts the value in
another; and the result is 0, the 0 is in brackets (0).

I've tried everything under the sun, but no can do! Any clues anyone?
TIA!