need some excel help cus i'm an idiot!

[Ladies Man]

4. Is the input in cell b12 of the database sheet a number?
(Remember use a Function to display the answer)


how do i get excel to tell if its a number or letters?

thanks

 

[Ladies Man]

no one???

 

[kranky]

ISNUMBER(B12) is the function to use. It will return "TRUE" or "FALSE"

 

[KEV1N]

If that doesn't work try IsNumeric()

 

[nateholtrop]

right click format and you should see it there.

nate