Hide zero values

[gary]

T13 contains this formula: =C13-K13 which displays 0.00
T14 contains this formula: =C14-K14 which displayed 79.04

To hide zero values, I select those cell and:
1. On the Format menu, I click Cells, and then click the Number tab.
2. In the Category list, ( click Custom.
3. In the Type box, I type 0;-0;;@

The results are:

T13 displays
T14 displays 79

How can I get T14 to display 79.04?

 

[GS]

gary submitted this idea :

T13 contains this formula: =C13-K13 which displays 0.00
T14 contains this formula: =C14-K14 which displayed 79.04

To hide zero values, I select those cell and:
1. On the Format menu, I click Cells, and then click the Number tab.
2. In the Category list, ( click Custom.
3. In the Type box, I type 0;-0;;@

The results are:

T13 displays
T14 displays 79

How can I get T14 to display 79.04?

Undo the Custom numer format and apply Conditional Formatting to change
the font color to match the cell color.

Alternatively, you can have your formula return an empty string since
calcs will ignore this cell anyway...

=IF(C13-K13=0,"",C13-K13)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[joeu2004]

T13 contains this formula: =C13-K13 which displays 0.00
T14 contains this formula: =C14-K14 which displayed 79.04
To hide zero values, I select those cell and:
1. On the Format menu, I click Cells, and then click the Number tab.
2. In the Category list, ( click Custom.
3. In the Type box, I type 0;-0;;@
The results are:
T13 displays
T14 displays 79
How can I get T14 to display 79.04?

Enter the Custom format 0.00;-0.00;;@ instead.

Alternatively: [=0]"";0.00