remove a zero value

  • Thread starter Thread starter angieg
  • Start date Start date
A

angieg

Good Morning all!!
I would like some help removing a zero value from a cell. I woul
prefer to replace all zero values with a blank cell. Does anyone ou
there know how to do this?
Thanks for all of your help, in advance.
Angi
 
Hi Angie

three options
1) tools / options / view - untick zero values
2) edit / replace 0 with nothing - make sure you tick the "match entire
cell contents" before doing this
3) if the 0 are the result of a formula, edit your formula to say
=IF(A1+B1=0,"",A1+B1) where A1+B1 is your current formula

hope this helps
Cheers
JulieD
 
Hi

If you want this for ALL zeroes, you could use Tools / Options / View .
and deselect Zero values.
 
Back
Top