Meet all How-To Articles

Format Phone Numbers With Dashes in Excel & Google Sheets

This tutorial demonstrates how to format phone numbers with dashes in Excel and Google Sheets.

format phone numbers 10

Format Phone Numbers

Say yous have a set of numbers and want to format them as phone numbers (see A2:A5 below). This formatting could include dashes, parentheses, and/or spaces.

format phone numbers 1

one. First, select the numbers you desire to format (A2:A5), and right-click the selection. From the driblet-downwards menu, choose Format Cells.

format phone numbers 2

2. In the Format Cells window, (1) click on the Number tab and from the menu (2) choose Custom. To format numbers in the Blazon box (3) enter the format you want. When you're washed, (4) press OK.

This example uses the format (###)###-####, but you could also use something else, like ###-###-####.

format phone numbers 3

Equally a upshot, the values are formatted every bit phone numbers.

format phone numbers 4

Phone Numbers With Land Code

If your phone numbers are all for the same country, you tin display the country code without editing the values.

format phone numbers 1

1. Select the list of numbers and correct-click it. From the drop-down menu choose Format Cells.

format phone numbers 2

2. In the Format Cells window, (one) click on Number and in the menu (2) choose Custom. Then, (3) type the format with country lawmaking – +ane (###) ###-#### – and when done, (four) press OK.

format phone numbers 5 new

Every bit a issue, the numbers are formatted with the country code, parentheses, and dashes.

format phone numbers 6 new

Strange Phone Number Format

This method works for any land, equally long as all numbers in the range are in that country. Just apply the applicative state code and standard formatting for that state. Just modify the Type: box text from Step ii above.

The example beneath appends state lawmaking 381 to phone numbers formatted every bit (##)###-##-##.

format phone numbers 8

Equally a outcome, the number is formatted every bit a strange telephone number.

format phone numbers 9

Format Phone Numbers in Google Sheets

i. To format numbers as telephone numbers with dashes in Google Sheets, offset select the list of numbers you want to format. Then, in the Menu click Format > Number > More Formats > Custom number formats.

format phone numbers 11

2. In the Custom number formats window, enter the format you want, and then click Utilise.

format phone numbers 12

As a consequence, the listing of numbers is formatted.

format phone numbers 15 new