unwanted zeros
 

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

unwanted zeros
 

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.



In article ,
"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

unwanted zeros
 

Greg,

Did you try
Tools/Options/View and uncheck "Zero Values"

John

"Greg Carter" wrote in message
...
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

unwanted zeros
 

tools options view uncheck the box for "zero values"


---
Message posted from http://www.ExcelForum.com/

unwanted zeros
 

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