Data validation - state characters allowed

[tlc53]

Hi there,

Due to other formula's relating to the cell containing this data validation, I need to amend it slightly.

It currently looks like this;

=OR(AND(ISNUMBER(B13),LEN(B13)=3),AND(ISNUMBER(LEFT(B13,3)+0),ISNUMBER(RIGHT(B13,3)+0),ISNUMBER(SEARCH("/",B13)),LEN(B13)=7))

I would like to amend the first part, so that the first 3 characters can only be "0123456789". Basically, I'd like it to treat the first 3 characters as text but only allow numbers to be entered, no letters. I came up with this but it is not working as I would like.

=OR(AND(ISTEXT(B13),"012345689",LEN(B13)=3),AND(ISNUMBER(LEFT(B13,3)+0),ISNUMBER(RIGHT(B13,3)+0),ISNUMBER(SEARCH("/",B13)),LEN(B13)=7))

Can someone help me with this please? Thank you

 

[J.Ty.]

Try
=OR(AND(ISTEXT(B13),ISNUMBER(VALUE(B13)),LEN(B13)=3),AND(ISNUMBER(LEFT(B13,3)+0),ISNUMBER(RIGHT(B13,3)+0),ISNUMBER(SEARCH("/",B13)),LEN(B13)=7))

 

[Yongle]

One way to test if the first 3 characters are numbers

=ISNUMBER(VALUE(LEFT(B13,3)))

 

[tlc53]

Try
=OR(AND(ISTEXT(B13),ISNUMBER(VALUE(B13)),LEN(B13)=3),AND(ISNUMBER(LEFT(B13,3)+0),ISNUMBER(RIGHT(B13,3)+0),ISNUMBER(SEARCH("/",B13)),LEN(B13)=7))

Perfect! Thank you