"Excel cannot find the data you're looking for"
The 0.00 was entered as a 0 in a Number format w/2 decimal places. Using an
empty cell with a General format and using = and a cell which shows 0.00 I
get 0.00 again, but still the same message when I try to find it.
--
LA Horowitz
"bj" wrote:
is the 0.00 in the sheet formatted that way?
if you use an empty cell and enter = (One of the cells which shows 0.00)
and make sure the cell format is general what do you get.
"LA Horowitz" wrote:
Using Find/Replace in excel, message comes up "Excel cannot find the data
you're looking for" even though I know many instances are there. I've
cleared the Find format, still get the error message. I'm searching for 0.00
if that makes any difference. I tried searching other strings of digits that
are in the worksheet and it works fine but not for 0.00. Thanks.
--
LeeAnn Horowitz
|