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
|