Select the cell or range of cells that you want to format. How to select cells or ranges?
On the Home tab, click the Dialog Box Launcher next to Number.
In the Category box, click Special.
In the Type list, click Phone Number.
How do I create a contact spreadsheet?
Start a new spreadsheet in Microsoft Excel. Go to the "File" menu at the top of the window and select "New" from the drop-down menu. You will use this new blank spreadsheet to enter your contact information.