View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Childs Tim Childs is offline
external usenet poster
 
Posts: 128
Default Using XP Operating System to Search for Numbers Values in Excel Files

Hi

I want to search for a numeric value (e.g. 283.57) in a large number of
Excel files stored in a directory.

While text seems to be stored as ASCII code and is visible in a file editor,
the numbers in Excel appear to be coded and certainly the XP file search
does not <do the business.

Are there any ways round this? (and, out of interest, can anyone tell me how
the numbers are stored?)

Many thanks

Tim

PS I have done some searches on the archive but not turned up anything
relevant/helpful.