Hide zero values

G

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?
 
G

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
 
J

joeu2004

gary said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top