Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ISNUMBER
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If IsNumber | Excel Programming | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions | |||
isnumber() | Excel Programming | |||
ISNumber VBA | Excel Programming |