Searching across multiple workbooks in Excel 2003

J

jrpfinch

I am trying to find a particular floating point value, 26663.1646555
(not from a formula), which I know exists in at least one workbook
using the File -> Open... -> Tools -> Search... facility in Excel.
The value displayed in the workbook I know it exists in is 26,664.

I am using the "Find Text or property includes" feature under the
advanced tab. Unfortunately whatever I put in the Value: box, it does
not find the workbook. I have tried:

26663.1646555
26,664
26664
26,663.1646555

Please could somebody let me know what I am doing wrong?

Thanks
 
Top