If you're looking for a funciton, try this:
=FIND(7,A1)=FIND(9,A1,FIND(7,A1)+1)-1
Where TRUE contains 79 and #VALUE! and FALSE Doesn't


"RobWN" wrote:

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