Add a restriction to a column
Solved/Closed
Aimz
-
3 Dec 2015 à 05:16
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Dec 2015 à 11:51
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Dec 2015 à 11:51
Related:
- Add a restriction to a column
- How to add a checkmark in word - Guide
- How to delete a column in word - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add at the rate in laptop - Guide
- Excel column number - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
3 Dec 2015 à 11:51
3 Dec 2015 à 11:51
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)
