Forum Discussion
Microsoft Form to Excel Formatting
Hello, In my form there is a box the asks for a phone number. I have set the restriction to numbers only; however, I would like the number to be presented in this format (XXX)-XXX-XXX. Is there ...
DingkunXie
Microsoft
Microsoft
There is no way to automatically enforce the format, but you can always manually format the data synced to Excel. It's important to keep in mind that you should avoid modifying the original Excel result table directly. Instead, copy it to another workbook and specify the cell formatting as 'phone number' to display the data as needed.