in a nonpivot table, I am trying just to hide the number zero sums. (not the
row or column.)

ideas?


TIA

formatconditional formattingformula is font same as background

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sundew Chocobo" wrote in message
...
in a nonpivot table, I am trying just to hide the number zero sums. (not
the
row or column.)

ideas?


TIA

Tools--Options--View check off Zero Values. You could also
incorporate an If statement into a formula, if you are only trying to
hide the 0s for formulated cells.
=IF(M5-M4=0,"",M5-M4)

Sundew Chocobo wrote:
in a nonpivot table, I am trying just to hide the number zero sums. (not the
row or column.)

ideas?


TIA

You can't "hide" a cell the way you can hide a row or column, but you can
make it appear blank.

Option 1: Wrap your formula in an if statement like this...
=IF(SUM(data)=0,"",SUM(data))

Option 2: Make a custom number format that outputs nothing for zero values.
highlight the cells in question
select format-cells-number tab
under "category" click on "custom"
enter the following under "type"
General;-General;;@

"Sundew Chocobo" wrote:

in a nonpivot table, I am trying just to hide the number zero sums. (not the
row or column.)

ideas?


TIA

The solution you choose will depend on how you want the zeroes to
affect other functions.

Option 1 is suitable if you want average function to ignore zero sum.
Option 2 is what you need to include the zeroes in AVERAGE(). Also,
COUNT() will omit blanks but include zeroes.

On Oct 8, 2:56 pm, Sloth wrote:
You can't "hide" a cell the way you can hide a row or column, but you can
make it appear blank.

Option 1: Wrap your formula in an if statement like this...
=IF(SUM(data)=0,"",SUM(data))

Option 2: Make a custom number format that outputs nothing for zero values.
highlight the cells in question
select format-cells-number tab
under "category" click on "custom"
enter the following under "type"
General;-General;;@



"Sundew Chocobo" wrote:
in a nonpivot table, I am trying just to hide the number zero sums. (not the
row or column.)

ideas?

TIA- Hide quoted text -

- Show quoted text -