Want to turn the digits in your spreadsheets into proper US phone numbers, with area codes? Instead of manually inserting hyphens and parentheses, use Microsoft Excel’s phone number formatting option.
In Excel, you can format your data in various ways. One such formatting is for US phone numbers, turning your numbers like “5555551234” into a readable “(555) 555-1234.” You can apply this formatting to several phone numbers at once if you want.
How to Apply Phone Number Formatting in Microsoft Excel
To start, open your spreadsheet with Microsoft Excel.
In your spreadsheet, select the cell or cells in which you have your phone numbers.
While your phone numbers are highlighted, in Excel’s ribbon at the top, click the “Home” tab.
On the “Home” tab, in the “Number” section, click “Number Format” (an arrow icon) at the bottom-right corner.
You will see a “Format Cells” window. Here, from the “Category” list on the left, select “Special.”
In the “Type” section on the right, click “Phone Number.” Then click “OK” at the bottom.
Note: If you don’t see “Phone Number” in the “Type” section, click the “Locale” drop-down menu and choose “English (United States)” or another supported country.
Back on your spreadsheet, all your phone numbers are now formatted in the proper phone number style.
If you’d like a different format for these numbers, then on the “Format Cells” window, select “Custom” and then specify your custom format.
And that’s how you turn ordinary digits into phone numbers in Microsoft Excel. Very useful!
Need to add a zero before a number in your Excel spreadsheet? If so, there’s an easy way to do that.