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

--
Regards
Frank Kabel
Frankfurt, Germany


OriginalStealth wrote:
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