SOLVED

Creating a format restriction for a phone number

%3CLINGO-SUB%20id%3D%22lingo-sub-1645486%22%20slang%3D%22en-US%22%3ECreating%20a%20format%20restriction%20for%20a%20phone%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1645486%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20set%20up%20a%20format%20restriction%20for%20a%20Text%20field%20for%20a%20phone%20number%3F%26nbsp%3B%20For%20example%2C%20123-456-7890.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1645486%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1647191%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20format%20restriction%20for%20a%20phone%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647191%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F786198%22%20target%3D%22_blank%22%3E%40JR2020610%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMicrosoft%20Forms%20doesn't%20allow%20for%20that%20type%20of%20formatting%20unfortunately.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20suggest%20using%20the%20subtitle%20to%20show%20an%20example%20of%20the%20desired%20format%20to%20help%20responders%20fill%20it%20in%20right.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20were%20using%20Power%20Automate%20to%20capture%20the%20results%2C%20you%20could%20also%20manipulate%20the%20number%20into%20a%20the%20desired%20format%20using%20an%20Expression.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%20with%20some%20ideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Is there a way to set up a format restriction for a Text field for a phone number?  For example, 123-456-7890.

 

Thanks in advance!

3 Replies
best response confirmed by JR2020610 (Occasional Contributor)
Solution

Hi @JR2020610 

 

Microsoft Forms doesn't allow for that type of formatting unfortunately.

 

I'd suggest using the subtitle to show an example of the desired format to help responders fill it in right.

 

If you were using Power Automate to capture the results, you could also manipulate the number into a the desired format using an Expression.

 

Hope that helps with some ideas.

 

Best wishes

Damien

 

 

Thanks Damien!

Microsoft Forms stinks in this regard; however, my best practice is to require only numbers in the field and limit entry between 2000000000 and 9999999999.

 

When you download your results into Excel, convert the fields to numbers (because for some reason the results download as text) and then format the cells using the "special" option for a phone number to generate data such as (201) 555-1212, etc.