Hiding amounts that equal 0

[Sandi]

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

 

[Bob Phillips]

Use Tools>Options>View and uncheck Zero Values

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

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.

 

[Jacob Skaria]

Select the range; Right click>Format Cells>select Custom and type the below

General;-General;""

If this post helps click Yes