View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Searching Excel Directory

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


Gord Dibben MS Excel MVP

On Thu, 14 Aug 2008 12:15:01 -0700, Mickey
wrote:

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