View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RobWN RobWN is offline
external usenet poster
 
Posts: 25
Default Find Numeric data

Is there any way to get the Find function to locate numeric values?
i.e. cells are formatted as Numbers with a comma separator for thousands and brackets for
negative values.
ex 1,079.00
A search for 79.00 returns any cell with 79.00 (179.00), 1,079.00 etc.

If I try an exact match (Match Entire Cell Contents) it finds nothing - I'm assuming because of
the sign byte.

--
Regards
Rob