=SUMPRODUCT(--(ABS(CODE(MID(A1, ROW(INDIRECT("1:" & LEN(A1))), 1)) -
52.5)<=4.5))0

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Fletcher" wrote in message
...
I tried that, but if the cell has numbers and text, it replies back with
FALSE. I would like to be able to determine if any part of the cell
contents is a number, even if the string starts with, or contains letters.

Thanks!

"LanceB" wrote in message
...
=ISNUMBER(a1)

"Fletcher" wrote:

I want a formula that will tell me if a given cell has a number in it,
so it
evaluates the type of data. I looked in the help files and couldn't
figure
this out.

Thanks,
Craig