In excel my find a value in a cell won't work. Why?

R

Rick in Colorado

I made a spreadsheet with 3 columns of numbers and 1 of dates. It is roughly
600 lines long, but when I try to "find" a value it comes back as not in
spreadsheet even though I see the value listed.

thanks
 
H

Harlan Grove

Rick in Colorado said:
I made a spreadsheet with 3 columns of numbers and 1 of dates. It is
roughly
600 lines long, but when I try to "find" a value it comes back as not in
spreadsheet even though I see the value listed.
Click to expand...

Two most likely possibilities are that the values you're trying to find
differ from the values in the spreadsheet due to rounding. For example, if
you see a 3 in a cell, that cell's *valus* might be 3.000000000001. If
you're checking whether the cell equals 3 *exactly*, that sort of search
will fail. Then again, you may have cells that look like numbers but are
actually text. 3="3" is FALSE in Excel.
 
Top