Find Command

[vikas0577]

Whenever while using the Find command ie. Ctrl+F , I try to find an amount with decimals for eg.123.00 then excel does not find the amount in the sheet. But if I remove the decimals then it will quickly find it. why is it so ? I have to use the find command very often and I have to remove the decimals for every search I do. How to simplify this Pl. help.

 

[Teeroy]

On the Find Box click the Options button and change the "Look In:" selection to Values.

 

[vikas0577]

On the Find Box click the Options button and change the "Look In:" selection to Values.

Thank You So Much... Such a silly thing.. any way Thanks once again.

 

[Teeroy]

You are welcome.