Validation Rule for 10 digit phone number

Question

_{Wednesday, August 8, 2018 12:51 PM}

Hi there,

I have a field that the type is "number" and called "Phone".

I need to create a validation rule that allows the user to only use 10 digits

for example "2106898756"

I use sharepoint 365...

Can anyone help me please?

All replies (5)

_{Wednesday, August 8, 2018 3:26 PM}

You may refer this blog for validation of phone:

https://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/ 

_{Thursday, August 9, 2018 2:42 AM}

Hi Konstantinos,

You may use a “single text” type(Because number type will generate comma automatically) for your “Phone” Column to avoid comma and then enter the following Formula in Column Validation of “Phone” Column to achieve your purpose:

=AND(ISNUMBER(Phone+0),LEN(Phone)=10)

Best regards,

Allen Bai

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

_{Thursday, August 9, 2018 6:21 AM}

Hello

Please try below link,

https://social.technet.microsoft.com/Forums/ie/en-US/5ae8e25a-38c0-416e-accb-03e2dbeeb8f4/sharepoint-phone-number-column-validation-formula?forum=sharepointgeneral

Thanks

_{Monday, August 20, 2018 2:14 AM}

Hi,

If you think my suggestion is helpful, you could mark it as an answer. It will help others who meet the similar question in this forum.

Best regards,

Allen Bai

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

_{Friday, August 24, 2018 6:56 AM}

Hi,

How are things going? I am willing to hear from you.

Best regards,

Allen Bai

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.