keeping a cell blank
 

how can i make a cell stay blank when the value is 0. especially when i have
a formula in that cell. for instance it may set to sum a range however that
range equals zero or some other formula that equals zero. I would like the
cell to stay blank. this is for a cover page report that pulls alot of data
from the enire workbook and i dont want it to be filled with a bunch of
Zero's

thanks

keeping a cell blank
 

Option 1: =IF(your_formula=0,"",your_formula)
Option 2: Format/ Conditional Formatting/ Cell Value Is/ equal to : 0/
Format font colour to white (or whatever your cell background colour is)
Option 3: Tools/ Options/ View/ deselect "Zero values"
--
David Biddulph

"James" wrote in message
...
how can i make a cell stay blank when the value is 0. especially when i
have
a formula in that cell. for instance it may set to sum a range however
that
range equals zero or some other formula that equals zero. I would like the
cell to stay blank. this is for a cover page report that pulls alot of
data
from the enire workbook and i dont want it to be filled with a bunch of
Zero's

thanks

keeping a cell blank
 

Click TOOLS/OPTIONS and on the VIEW tab, locate the checkbox at bottom center
named ZERO VALUES and remove the checkmark.

Hope this helps...
--
Kevin Backmann


"James" wrote:

how can i make a cell stay blank when the value is 0. especially when i have
a formula in that cell. for instance it may set to sum a range however that
range equals zero or some other formula that equals zero. I would like the
cell to stay blank. this is for a cover page report that pulls alot of data
from the enire workbook and i dont want it to be filled with a bunch of
Zero's

thanks

keeping a cell blank
 

hi
you could use an if formula in place of your other formula.
=if(sum(range=0),"",sum(range))
the formula would still be in the cell but the cell would display a blank.

regards
FSt1

"James" wrote:

how can i make a cell stay blank when the value is 0. especially when i have
a formula in that cell. for instance it may set to sum a range however that
range equals zero or some other formula that equals zero. I would like the
cell to stay blank. this is for a cover page report that pulls alot of data
from the enire workbook and i dont want it to be filled with a bunch of
Zero's

thanks

keeping a cell blank
 

Kevin B comes to the resue again.... Thanks


"Kevin B" wrote:

Click TOOLS/OPTIONS and on the VIEW tab, locate the checkbox at bottom center
named ZERO VALUES and remove the checkmark.

Hope this helps...
--
Kevin Backmann


"James" wrote:

how can i make a cell stay blank when the value is 0. especially when i have
a formula in that cell. for instance it may set to sum a range however that
range equals zero or some other formula that equals zero. I would like the
cell to stay blank. this is for a cover page report that pulls alot of data
from the enire workbook and i dont want it to be filled with a bunch of
Zero's

thanks