< All Topics Main Microsoft Office How to Format Phone Numbers in Microsoft Excel Print How to Format Phone Numbers in Microsoft Excel PostedDecember 22, 2021 UpdatedDecember 22, 2021 ByAdministrator 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.RELATED: How to Highlight a Row in Excel Using Conditional FormattingHow to Apply Phone Number Formatting in Microsoft ExcelTo 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.”n 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!(source: https://www.howtogeek.com/766731/how-to-format-phone-number-in-microsoft-excel/)