Contents
How to validate a single line of text column?
Validate a Single line of text column type of list in sharepoint 2010 to accept only alphabets? How to validate a Single line of text column type of list in sharepoint 2010 to enter accept only alphabets? no special character and no number should be allowed in that field.
How to validate a column in Microsoft Excel?
In the Column Validation settings (Edit the Column and it is an expandable section near the bottom) you can use this formula: =ISNUMBER ([My Column]+0) Just Replace My Column with your actual Column’s name
How to validate if the entered text is number?
I have a column named Year of type Single line of text. I would like to be able to stop the user if he or she enters the text other than number. By the way, I don’t want to have my column as Number; this solution t doesn’t work for my design.
According to formula if the user gives the mobile number in the below format then only the field will take the mobile number. I have created a new item in the phone number field I have given the number as “+91-**” So the number is stored to the SharePoint list. Now, we will see how to an example on SharePoint date column validation.
To do this, we’ll use the MID function like so: =MID ( [SSN],4,1=”-“). This tells SharePoint to extract a string out of the MIDdle of our field that is 1 character long and begins with the character in the 4th position, then check to see if it is a dash.
How to validate a mobile number in SharePoint?
In the User message I have added the message “Enter the valid mobile number”. According to formula if the user gives the mobile number in the below format then only the field will take the mobile number. I have created a new item in the phone number field I have given the number as “+91-**” So the number is stored to the SharePoint list.