Find & Select

C

Celeste

I asked Excel to find a number I know is there - I'm looking at it. Why
doesn't it see it?
 
L

Luke M

Check under Find Options, make sure XL is looking at values, not formulas?
Or, see if "exact match" is enabled. This would cause a search for "1234" to
not find the cell "1234 ".
 
D

David Biddulph

Just because you can see it doesn't mean that it's there. :)

If a cell contains 123.999999 it may well display as 124. Cntrl-F and look
for 124 won't find it; Cntrl-F and look for 123 will find it.
It's worth clicking in the cell and seeing what the format bar shows.
 
Top