How to return blanks for $0.00 cells?

first time poster.. any help would be appreciated

I would like to return a blank cell when the sum of cells is $0.00

attched is a pic... currently the total column is derived from the sum of cells in columns H J L & M (labelled Fee)... when there is no data in a specific row, then the sum formula returns $0.00... how do i change this so it will be a blank cell until a real total is calculated?

current formula in O2 is =SUM(H2,J2,L2,N2)

many thanks
muttsa

\1

Very simple,
Tools
Options
Uncheck the box "zero Options" near the bottom

Originally Posted by bnwash

Very simple,
Tools
Options
Uncheck the box "zero Options" near the bottom

Thanks!

feel a little foolish now!

Hi DrMutley,

bnwash's solution is definitely your answer.

I'd like to make a point too, that sometimes it's worth having something there. For argument's sake, sometimes it's good to know if a cell is a zero value, or a blank entirely.

The circled items in the formatting toolbar (see pic attached), can be quite useful. For example, you can use the "$" for cells with currency values, or <comma> for cells with decimal values. Using this would mean that zero values appear as a <dash>.

It can make your presentations look elegant too, I think.

Cheers,
smz.