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