Macro for reformatting cells
 

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

Macro for reformatting cells
 

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

Macro for reformatting cells
 

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

Macro for reformatting cells
 

Great! Thanks so much! I guess I need to spend more time checking out the
ToolsOptions dialogue boxes -smile

"Jim Thomlinson" wrote:

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

Macro for reformatting cells
 

Thanks Paul, that does the trick!

"Paul B" wrote:

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