| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Numeric sign in a string | Excel Worksheet Functions | |||
| Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
| Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
| Find numeric value at end of string | Excel Worksheet Functions | |||
| Find first numeric value in text string | Excel Worksheet Functions | |||
Threaded Mode
