Hiding amounts that equal 0
 

Is there a formula that you can use that says if the amount is 0 nothing
showes in box?
--
Sandi

Hiding amounts that equal 0
 

Use ToolsOptionsView and uncheck Zero Values

--
__________________________________
HTH

Bob

"Sandi" wrote in message
...
Is there a formula that you can use that says if the amount is 0 nothing
showes in box?
--
Sandi

Hiding amounts that equal 0
 

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

=IF(A1="","",A1)


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 15:22:01 -0700, Sandi
wrote:

Is there a formula that you can use that says if the amount is 0 nothing
showes in box?

Hiding amounts that equal 0
 

Hi,

besides the suggestions you already have you can create a custom format such
as:

General;General;;

Choose Format, Cells, Number tab, Custom and enter something like the above.
Change the number of decimal

or you can use conditional formatting:

Format, Condtional Formatting, choose equal to from the second box and enter
0 in the next box, then click Format and on the Font tab set the color to
White.



--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sandi" wrote:

Is there a formula that you can use that says if the amount is 0 nothing
showes in box?
--
Sandi

Hiding amounts that equal 0
 

Select the range; Right clickFormat Cellsselect Custom and type the below

General;-General;""

If this post helps click Yes
---------------
Jacob Skaria


"Sandi" wrote:

Is there a formula that you can use that says if the amount is 0 nothing
showes in box?
--
Sandi