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