Or you could adjust the formula:

=if(yourformulahere="","",yourformulahere)

I like the formula approach because I can still see the zeros that should be
returned.



Greg Carter wrote:

I have some cells that have formulas in them on and
old spreadsheet, and when the value of the formula is
zero, the cell is blank.
I can't remember how I achieved this as I'm having
problems repeating it in my new sheet.
Format painting the old to the new won't do it.
Formatting cells on the old sheet shows me
the "general" number format is used, and the example is
blank.
On the new one, a value of zero is showing in the
example box.
I thought text formatting would work, but no.
Can you help?
Thanx ahead, Greg Carter

--

Dave Peterson