ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Searching across multiple workbooks in Excel 2003 (https://www.excelbanter.com/excel-programming/435790-searching-across-multiple-workbooks-excel-2003-a.html)

jrpfinch

Searching across multiple workbooks in Excel 2003
 
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


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com