You could try


=IF(OR(LEFT(A1,1)={"0","1","2","3","4","5","6","7" ,"8","9"}),"yes",FALSE)

and leave the ,False off if you just wish it to default to False.

--


JudithJubilee Wrote:
I've been playing with this prob and the following formula works
although it
is rather long!

=IF(OR(LEFT(A1,1)="1",LEFT(A1,1)="2",LEFT(A1,1)="3 ",LEFT(A1,4)="1",LEFT(A1,5)="1",LEFT(A1,6)="1",LEF T(A1,7)="1",LEFT(A1,8)="1",LEFT(A1,9)="1",LEFT(A1, 1)="0"),A1,FALSE)

Someone probably has an easier solution though so wait around!

Judith
--
Hope this helps


"David" wrote:

Bob Phillips wrote

=IF(ISNUMBER(A1),A1,FALSE)

OP said:
I want to be able to make this work if any number 0-9 is the first
character in the cell,

--
David



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535423