Zero values displaying as "-"
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
"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!
|