View Single Post
  #3   Report Post  
Fletcher
 
Posts: n/a
Default

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