I would like to use a number field to add phone number to a Sharepoint list. But if the phone number starts with 0, it is automaticly removed by default. Is there any way to keep it? I didn't want to use text field to ensure users not enter non number characters.

  • 3
    A number can't begin with a zero if it's not a decimal number. I would use a single line of text. Jul 5 '18 at 8:37

I tried adding an out-of-the-box 'telephone number' field, Primary Phone, to a list, but it is a text field.

So, I found this other post which deals with your issue. It seems there is no very simple solution to this, as Sharepoint automatically disregards a 0 in a number field.

I've added a picture - I'd already created this field, so I think it shows with brackets () instead of square brackets []

create edit field

  • Well I tought so, just hoped maybe there is an easy solution. Thanks for the link. I have bad experience with calculated fields, it can be bugged with low chance so I wanted to avoid using it, but looks like no other way.
    – Nefri
    Jul 5 '18 at 8:53
  • @Nefri, no calculated fields are needed. You must place this formula in validate column section on your column edit page.
    – AlexZh
    Jul 5 '18 at 8:54
  • I've added a picture to show the screen AlexZh is referring to
    – Tally
    Jul 5 '18 at 9:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.