If the Sum value or any value equals 0...I want just left bl

[CAPT.PT]

I do not want the value of 0 to showup...what can I do to stop it?

 

[Mark W.]

Format as...

0;-0;

 

[CAPT.PT]

thanks Mark....take a simple formula...
=SUM(D9:Q9) where do I add 0;-0;

just a begininger sorry

 

[Yogi Anand]

Hi Capt.pt:
In addition to what Mark suggested, if you do not want 0s (zeros) to display, you can do this by TOOLS|OPIONS|VIEW ... and uncheck the Zero values box. You are unchecking the box to signify your intention that whereever the value is 0 (zero) it will not be displayed.

HTH

 

[Mark W.]

On 2002-03-20 11:29, CAPT.PT wrote:
thanks Mark....take a simple formula...
=SUM(D9:Q9) where do I add 0;-0;

just a begininger sorry

With the cell containing the formula, =SUM(D9:Q9), selected choose the Format | Cells... menu command, click on the "Custom" category and enter 0;-0; in the "Type" field.