How do I hide 0's from showing in a table?

[Randy Williams]

I need assistance please. I have a large Excel table with zeros in the
majority of cells. I want to "hide" the zeros but leave the non-zero numbers
showing, for easy viewing by users. And I would rather not have to delete by
hand each cell containing zero.
Does anybody have a clever solution? I would appreciate it. Thanks in advance.

 

[papou]

Hi
Tools, Options, View and Untick "zero values"
HTH
Cordially
Pascal

I need assistance please. I have a large Excel table with zeros in the
majority of cells. I want to "hide" the zeros but leave the non-zero numbers
showing, for easy viewing by users. And I would rather not have to delete by
hand each cell containing zero.
Does anybody have a clever solution? I would appreciate it. Thanks in

advance.

 

[Frank Kabel]

Hi
one way: use a custom format such as
0.00;-0.00;

 

[Larry]

I know of two ways that may help. First, got to "Tools" and select
"Options". Under the "View" tab, in the Window options area, uncheck "Zero
Values" and save your work. The other way involves nesting an IF formula
within a specific cell or group of connected cells. Hope this helps.

Regards,
Larry

 

[karen]

You can also use a conditional format
Highlight the table click format conditional formatting, cell value IS,
equal to 0 click format click color and change it to white. the zeros
remain you just can't see them.
karen