Add a restriction to a column

Solved/Closed
Aimz - Dec 3, 2015 at 05:16 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 3, 2015 at 11:51 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 3, 2015 at 11:51 AM
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)
2