Formatting zeros

[OriginalStealth]

I have a spreadsheet with currency values in cells D16-
H50. Column H is the last column in the spreadsheet. How
can I automatically have all the cells with a 0 in it
change to the dash(-) when it's is opened?

Thanks in advance.
OS

 

[Frank Kabel]

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