Searching Excel Directory

M

Mickey

Hi,
I store alot of excel spreadsheets in a directory. The spreadsheets contain
numbers. When I search the directory for a specific number it does not find
it. It will only find words. Is there a trick to get it to find numbers.

Thanks,
Mickey
 
G

Gord Dibben

None that I know other than to preface the numbers with an apostrophe or
format as text.


Gord Dibben MS Excel MVP
 
Top