Thread
:
ISNUMBER
View Single Post
#
6
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
ISNUMBER
one way? if the first char is a number
=ISNUMBER(VALUE(MID(I1,1,1)))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"johnrb7865" wrote in message
...
Hi, does anyone know the best way to test if the 1st character in a cell
in a
number or a letter in an IF statement? I tried
=IF(ISNUMBER(MID(A1,1,1)),do
this if true, do this if false where A1 could be a202 or 202 and it didn't
work. I clearly don't understand the ISNUMBER command. I even tried it
alone
=ISNUMBER(MID(A1,1,1) where A1 was a202 and 202 and they both came back
FALSE. Any ideas?
Thanks,
John
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett