Formatting Zero Values

[Guest]

I have a range of cells with numeric values, some of which are formulas.

When the cell value is zero I would like to display a hyphen "-" rather than
0 or blank.

Does anybody have a way to do this, preferably with a custom formatting that
can easily be applied to each cell?

Thanks, Kaval

 

[Frank Kabel]

Hi
use a custom format like
0;-0;"-"

 

[Guest]

Thanks Frank!!!

Hi
use a custom format like
0;-0;"-"