Window Explorer search cannot find number

[Mitch]

I tried to using the search function in window explorer to find a
certain number in a excel file using the "Containing text" text box in
the Window Explorer search. the number is in an M/S Excel file.
Sometime the search will find the file containing the number, other
time it will not find the file. However, I know the number is in the
excel file and I am able to use Excel find feature to find it.

Any help would be appreciated

Thanks

 

[Pegasus \(MVP\)]

Numbers are not normally shown as decimal numbers in
Excel - they are probably visible as hexadecimal numbers.
The number "100", for example, might be shown as "64"
whereas "200" might be "C8".

 

[Jeremy Winston]

Numbers are not normally shown as decimal numbers in
Excel - they are probably visible as hexadecimal numbers.
The number "100", for example, might be shown as "64"
whereas "200" might be "C8".

But it's even worse than that, since the binary value of
a number will likely be interpreted as an ASCII character,
so there may be another level of indirection.

E.g., dec 132 = 0x20 = ASCII 'ä'.

-Jeremy(Unless of course MS's search tool interprets MS
files intelligently...)