"Excel cannot find the data you're looking for"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
If the number is actually zero, you won't find 0.00.
If the number is 0.002, then you'll find 0.00 within it, but if you've got
zero *displayed* as 0.00, then you won't find it if you look for 0.00
 
Excel searches for the actual contents of a cell. If you enter 0 in a cell
Excel will find it searching for 0. Changing the cell's number format to
show 1, 2 or 10 decimal places does not change what is in the cell.

--
Jim
| 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
 
Got it - thanks.
--
LA Horowitz


David Biddulph said:
If the number is actually zero, you won't find 0.00.
If the number is 0.002, then you'll find 0.00 within it, but if you've got
zero *displayed* as 0.00, then you won't find it if you look for 0.00
Click to expand...
 
Back
Top