When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number. If ...

Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...