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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 3, 2015 at 11:51 AM
Related:
- Add a restriction to a column
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add songs to sound picker - Guide
- How to add @ in laptop - Guide
- Add messenger to home screen - Guide
- How to add a tick in word - Guide
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
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)
is validates your check of starts with 03 and length = 11
=AND(LEFT(A1,2)="03", LEN(A1)=11)