Search is complete. There are no results to display.

B

BJP

I am search for an Excel spreadsheet having a particular value in a cell.
Search Companion returns the message "There are no results to display.", when
if fact I know that the values is in one of the several spreadsheets I am
searching. When I do a "Find" for the value in these spreadsheets I find the
cell. The value is numberic in a text field (e.g.: 49804418) and yet Search
Companion doesn't find the file. What could be the problem?
 
P

PD43

BJP said:
I am search for an Excel spreadsheet having a particular value in a cell.
Search Companion returns the message "There are no results to display.", when
if fact I know that the values is in one of the several spreadsheets I am
searching. When I do a "Find" for the value in these spreadsheets I find the
cell. The value is numberic in a text field (e.g.: 49804418) and yet Search
Companion doesn't find the file. What could be the problem?

Dunno.

Perhaps you would have better luck posting your question in an Excel
group, eh what?

Try this link:

http://groups.google.com/groups/dir?&sel=33607952&expand=1
 
H

HeyBub

BJP said:
I am search for an Excel spreadsheet having a particular value in a
cell. Search Companion returns the message "There are no results to
display.", when if fact I know that the values is in one of the
several spreadsheets I am searching. When I do a "Find" for the
value in these spreadsheets I find the cell. The value is numberic
in a text field (e.g.: 49804418) and yet Search Companion doesn't
find the file. What could be the problem?

You have written the number as text base 10. Excel may be storing the number
in some other fashion.

For example, 49804418 may be stored as "4.9804418E07"

"AAAAAAA" may be stored as "6*A"

and so on. Unless you know the conversion/compaction/shorthand the program
uses, you're out of luck.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top