None that I know of without using VBA

Display of zeros is a worksheet/window setting.

BTW............don't use quotes around the 0 in your formula.

=IF(result=0,0,result)


Gord


On Tue, 18 Aug 2009 06:03:01 -0700, SteveM
wrote:

There are a lot of cells with formulas, some quite large, the majority of
them giving a zero result, which is why I want to hide them, hopefully
without extra "if's". That is why I chose to not display zero results.
However I have some cells on the same sheet I want to show a zero result (if
applicable). Is there any way besides doing an "if" with a text zero, such
as =if(result=0,"0",result) ??

"SteveM" wrote:

I have a select number of cells that I would like to show zeros (if
applicable) even though the worksheet is set to not show zeros. How can I do
that with those select cells, either by settings or programming?