excel

[ashling]

can someone please help with function CTRL+F TO FIND IN
EXCEL 2000.
I am using to find a figure eg 9.10, sometimes it works
sometimes it does not.
Please Advise
thank you

 

[David]

Ashling

It should work (works for me).

However if you want to find a 9.10 which is the result of a formula, rather
than an actual 9.10 entered as such, you need to go into Options (on the
Find and Replace panel) and change the Look in entry to Values (not
Formulas).

HTH

David