Add a restriction to a column

Solved/Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should start from 03 then other 9 characters are to be added) is there a formula, can this be done.
Thank you for your time :)

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you have to use validation with custom formula

is validates your check of starts with 03 and length = 11
=AND(LEFT(A1,2)="03", LEN(A1)=11)