Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numeric search windows explorer
My question here is sort of related to excel.
I am using windows search to search for a phrase in a file. If I enter 123456 and search excel files it DOES NOT find the match. Even though 123456 is a numeric field in excel. Is there a way to accomplish this? I notice it puts quotes" around the 123456. Is there something different I should do so it will search numeric fields in the excel file? thanks, ga George Applegate c |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
numeric search windows explorer
First of all you need to make sure the file is saved. Then search 123456 in
the second part where it says "a word or phrase in the file". Not where it says "all or part of the file name". "George Applegate" wrote: My question here is sort of related to excel. I am using windows search to search for a phrase in a file. If I enter 123456 and search excel files it DOES NOT find the match. Even though 123456 is a numeric field in excel. Is there a way to accomplish this? I notice it puts quotes" around the 123456. Is there something different I should do so it will search numeric fields in the excel file? thanks, ga George Applegate c |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
numeric search windows explorer
Art, thanks for your suggestions but that's what I'm doing.
I think what is happening is it is only searching "text" data and not numeric data???? I am running windows xp service pack 3 and it flat out don't work. ga art wrote: First of all you need to make sure the file is saved. Then search 123456 in the second part where it says "a word or phrase in the file". Not where it says "all or part of the file name". "George Applegate" wrote: My question here is sort of related to excel. I am using windows search to search for a phrase in a file. If I enter 123456 and search excel files it DOES NOT find the match. Even though 123456 is a numeric field in excel. Is there a way to accomplish this? I notice it puts quotes" around the 123456. Is there something different I should do so it will search numeric fields in the excel file? thanks, ga George Applegate c George Applegate c |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for Excel worksheet in Windows Explorer using dollar value | Excel Discussion (Misc queries) | |||
Windows Explorer | Excel Worksheet Functions | |||
windows explorer to excel | Excel Discussion (Misc queries) | |||
Windows Explorer maximizes over XL 2000, if opened w/ explorer | Excel Discussion (Misc queries) | |||
search by date in windows explorer | Excel Discussion (Misc queries) |