[Bob I]

You say it only works sometimes, compare the circumstances that work
with the one that does not work. What are the differences?

Dima wrote:

Thanks Bob I for your reply!
It is not a protected file or cells.
Excel does not find any variations in the representation of my number. I
search for the number, shown in a cell and in the formula bar. I type it in
the "Value" field with the "Text or property" selected. I selected the file
folder in the "Results should be" and the Excel file type in the "Search in".
Best regards,
Dima
"Bob I" wrote:


Search WILL find a number in a cell in an Excel spreadsheet. The
question is what are you actually searching for, as compared to what you
expect it to find. You have NOT given an example of this. So we will
have to keep guessing until you discover what causes your search to not
return what you expect. Excel will find many variations in the
representation of a number. So the issue is something that your system
is set to or configured to do that is causing the issue. Is it perhaps a
protected file or cells?

Dima wrote:

Thanks Bob I for your thought!
There is no a "number in Excel", but only "text or property" in the Property
list in the Advanced file search.
Why does not the "text or property" search for a number in the Excel? How to
find an Excel file with the number in its cell then?
Best regards,
Dima
"Bob I" wrote:



Perhaps the text that you are searching for and the "number in Excel"
are not the same thing? They only appear similar to the user?

Dima wrote:



Thanks Bob I for your helping questions!
Yes, the search criteria is being added to the "includes".
It was working before partially. It did not find all files.
I have tried Windows 2000 file search. It did not find the excel file by a
number in its cell too.
Best regards,
Dima
"Bob I" wrote:




I am puzzled as to why it is not finding the file then. Have you tried
several different searches? Is the search criteria being added to the
"includes"? Was it working before?

Dima wrote:




Thanks Bob I for your questions!
Yes, the Location is actually accessible, in NOT a hidden or system folder.
I can browse to those files and open them.
"Bob I" wrote:





Is the Location actually accessible? As in NOT a hidden or system folder?

Dima wrote:





Thanks Bob I for replying.
That goes without saying. I set file types and Search Location also.
Best regards,
Dima
"Bob I" wrote:






You need to Set file types and Search Location also.

Dima wrote:






Hello!
How to make the Office 2003 Advanced file search to find files by the "text
or property"? The Office 2003 sp2 Advanced file search does not find a Word
or Excel file by a word or a number in an excel cell.
Best regards,
Dima
+79035093892