=ISNUMBER(A1)

tests for a number, but that will also pass 123

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mickbarry" wrote
in message ...

Hi all,
I need a function which tells me if a cell contains
an alpha character.
That is if cell contains "g" then True
if cell contains 7 then False

Regards Mick Barry

There are never enough hours in the day, but always too many days
before Saturday.


--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile:
http://www.excelforum.com/member.php...o&userid=31028
View this thread: http://www.excelforum.com/showthread...hreadid=509582