Formatting Zeros
 

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

Formatting Zeros
 

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

Formatting Zeros
 

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

--
Regards,
Tom Ogilvy

"OriginalStealth" wrote in
message ...
thanks frank that worked. How do I get the blank cells to show a dash(-)
also. When the sheet opens all blank cells and zeros must be in the form
of
a dash.

"Frank Kabel" wrote:

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