Forum Discussion
Column Validation for Phone Number Code?
Dear SP Gurus, Does anybody know the rule I need to place in the phone number column settings so I can valadate a user's entry of a phone number? I would like it to be in the following format. 555-...
Hi,
You can achieve this by using calculated column.
create 2 columns
1.ContactNumber -Single line of text(for example).
2.Phone Number -Calculated Column(to show actual Phone Number).
Insert following formula in Phone Number formula field
=TEXT(ContactNumber,"000-000-0000")
Now on default view, you can hide Contact Number Column.
Create a new Item and you done.
Insert data
Your Final View
Cheers !