Phone Number Format in Excel

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.

phone number with dashes or spaces

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.

Phone number with dashes and parenthesis

Leave a Reply

Your email address will not be published. Required fields are marked *