edicehouse
Member
If you have a formula in a series of cells and the result is a "0" what can you put in the whole sheet if the resulting answer is 0 how do you make it blank?
EXCEL 2007 QUESTION
- Thread starter edicehouse
- Start date
Signed-In Members Don't See This Ad
Signed-In Members Don't See This Ad
Andrew_K99
Member
You want zero values to display as blank?
I have 2010 (which has annoying changed alot from 2007) so forget where to find it, but it is in the options dialog box, turn off 'display zero values'
Here is a link to do it in 2007 http://office.microsoft.com/en-us/excel-help/display-or-hide-zero-values-HP010070461.aspx
AK
I have 2010 (which has annoying changed alot from 2007) so forget where to find it, but it is in the options dialog box, turn off 'display zero values'
Here is a link to do it in 2007 http://office.microsoft.com/en-us/excel-help/display-or-hide-zero-values-HP010070461.aspx
AK
Last edited:
Ed McDonnell
Member
Depending on what you are doing you can also use conditional formatting. Set zero values to match the background to make them disappear. Or set them to a low grey value so they aren't noticeable, but you can still tell what cells you have formulas in.
Ed
Ed
GoodTurns
Member
=if(YOUR FORMULA)=0,"",(YOUR FORMULA))
Andrew_K99
Member
The problem with using the double quote ("") is that it changes the format of the cell to text which won't let you use the results in another formula.
AK
edicehouse
Member
Got it from the link. Thanks guys.