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.

alt=""

The Format Cells dialog box will open.

On the Number tab, select Special from Category and then choose Phone Number.

alt=""

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 *