ExcelBanter - View Single Post - In excel my find a value in a cell won't work. Why?

"Rick in Colorado" <Rick in wrote...
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.

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.