Here is a great tip to save you some time when entering phone numbers into Excel.
When entering a phone number into a cell, it is faster to just type the number without the dashes or parenthesis. You can format a cell to automatically format the phone number for you.
On the Home Tab, in the Number group, click the launcher arrow.
The Format Cells dialog box will open.
On the Number tab, select Special from Category and then choose Phone Number.
Click Ok.
Enter the phone number – just enter the numbers and when you hit Enter, the formatting is done.