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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick in Colorado - 17 Dec 2005 01:46 GMT

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

Reply to this Message

Harlan Grove - 17 Dec 2005 06:18 GMT

"Rick in Colorado" <Rick in Colorado@discussions.microsoft.com> 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.

Reply to this Message