Select Tools - Options and on the View tab uncheck Zero Values
--
HTH...

Jim Thomlinson


"Gina_Louisville" wrote:

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