Show Zeros in some cells even though worksheet set to not show zer
 

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?

Show Zeros in some cells even though worksheet set to not show zer
 

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?

Show Zeros in some cells even though worksheet set to not show zer
 

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?

Show Zeros in some cells even though worksheet set to not show zer
 

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?

Show Zeros in some cells even though worksheet set to not showzer
 

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 -

Show Zeros in some cells even though worksheet set to not show zer
 

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?

Show Zeros in some cells even though worksheet set to not show zer
 

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 -