Gina, one way, tools options, view, uncheck zero valves
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Gina_Louisville" wrote in
message ...
I have a large grid with a different formula in every cell. at the end of
calculation, more than half of the cells will be a zero currency balance.
I
want these cells to keep the formula but present a blank format. Is there
a
macro or other way to achieve this? Thanks