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?

Enter 0.001 and format the cell with a custom format of 0
--
Jim Cone
Portland, Oregon USA



"SteveM"
wrote in message
...
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?

Generally if a 0 is a result of a formula you just trap for it and hide it.

=IF(A1 + B1=0,"",A1 + B1)

If you want to see the 0 don't trap

=A1 + B1

I never use the "don't display zeros" option.

I like to see them sometimes............sometimes not.


Gord Dibben MS Excel MVP

On Mon, 17 Aug 2009 14:57:01 -0700, 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?

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?

You can use conditional formatting on the cells with a zero result -
choose Cell Value Is, then 0 (zero) and choose a white foreground
colour (assuming you have a white background colour). The zero will
not show.

Hope this helps.

Pete

On Aug 18, 2:03*pm, 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?- Hide quoted text -

- Show quoted text -

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?

Forgot about that.

Thank Pete


Gord

On Tue, 18 Aug 2009 06:11:29 -0700 (PDT), Pete_UK
wrote:

You can use conditional formatting on the cells with a zero result -
choose Cell Value Is, then 0 (zero) and choose a white foreground
colour (assuming you have a white background colour). The zero will
not show.

Hope this helps.

Pete

On Aug 18, 2:03*pm, 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?- Hide quoted text -

- Show quoted text -