View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Uncle Ben
 
Posts: n/a
Default Zero values displaying as "-"

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!