delete 0 values

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi I am trying to delete cells with 0 values, even though i type in $0.00 in
find, it finds nothing.

i get the message find under values not formulas, but there is no option for
this in the find options.

thanks tim
 
If you ask find to look for $0.00, then it will search for the text
string "$0.00". If you want to find numeric zeros (regardless of
format), then just type 0 in find.

If that fails to find any, then I suspect that the values you see as
zero are not exactly zero (try formatting in scientific notation).

You can use the ROUND() function to force the results of any particular
calculation to any desired number of decimal places. Alternately
Tools|Options|Calculation|Precision as displayed will reduce the
precision of all calculations to the display precision defined by cell
formatting.

Jerry
 
Thanks for the reply. If I searched for 0 you get every 0 ie, nearly every
cell. I ended up using conditional formatting and making 0 cells "disappear"
thanks tim
 
Back
Top