=istext("123xd")
returns true
=isnumber("123xd") return
false

I am not sure of isnumeric function unless its a UDF, which is why it reyrns
true for part text and part number


"thephoenix12"
wrote in message
news:thephoenix12.1r3i6w_1119557148.1824@excelforu m-nospam.com...

Hi,

I know that IsNumeric returns true if the selection is only numbers,
but is there a function that returns true if the selection is all text?
Using If Not IsNumeric does not work, because if something contains text
and numbers it returns true, which is what I do not want.

Thanks,

Steve


--
thephoenix12
------------------------------------------------------------------------
thephoenix12's Profile:
http://www.excelforum.com/member.php...o&userid=24336
View this thread: http://www.excelforum.com/showthread...hreadid=381736