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