How to Format Excel Cells for Phone Numbers



To format excel cells for phone numbers Click Format on the top middle of the Excel spreadsheet.
Click on format at the top in the menu bar

From here click Cells
Select Cells in the format dropdown

Next, click on the Number tab at the top and select the “Text” option
Click on Number and select Text to the left

When finished, click OK at the bottom of the window
Click ok when you have made your changes

You’ve now formatted the cells to display phone numbers correctly.
Phone numbers will now be displayed properly

Related posts:

  1. How to Attach Excel File in PowerPoint 2007
  2. How to Export Data from Excel 2010 to Pipe Delimited Text File
  3. How to Arrange Excel 2010 Cells by Datе Order
  4. How to Make a Drop Down Menu in Excel 2007
Posted on February 25, 2013 by . This entry was posted in Office and tagged . Bookmark the permalink.