unwanted zeros

  • Thread starter Thread starter Greg Carter
  • Start date Start date
G

Greg Carter

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
 
Couple of ways:

1) Tools/Options/View, uncheck the Zero values checkbox.

2) Format/Cells/Number/Custom General;General;;@

3) Format/Conditional Format... Set the font color to the background
color if the cell value is 0.
 
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.
 
Back
Top