forgotten

  • Thread starter Thread starter Beeel
  • Start date Start date
B

Beeel

Hi
I haven't been working for a while and have forgotten how to hide zeros in a
part of a spreadsheet

Barry
 
If it's just part of a worksheet, you can use a custom format like:

General;-General;;@


if the values are the results of a formula, you could do something like:

=if(yourformula=0,"",yourformula)
 
Thanks those who sent replies. I only need zeros suppressed in one range not
the whole sheet.
I have formatted cells "0;-;;@" which works but someone once showed me
simple keystroke method
which I believe was CTRL and something

Barry
 
Back
Top