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?

I Really need the code because I suck at excel.

Thanks in advance.
OS

 

[Frank Kabel]

Hi
use a custom format 8no coede needed) goto the menu 'Format - Cells'
and apply the custom format
0.00;-0.00;"-"

 

[Tom Ogilvy]

Blank cells don't display anything. You would need to put a zero in them.