As excel takes a phone number as a series of numbers, it can eliminate the zeros at the start of the string because it provides no value to the number. Some countries may have phone numbers starting with 0. Read More: How to Format Phone Number with Dashes in Excel (2 Ways)ġ.4 Write Phone Number Starting with Zero Now we can see the phone numbers have changed the way we have written them in the Type bar. Next, write #-#-# or 00 in the Type bar and click on OK.After that, open up the Format Cells dialog box either through the Home tab or using the shortcut Ctrl+1.In my case, it is the range of cells C5:C11.

If you want to format the same number to visually separate it differently, or maybe for a different country.

Thus you can achieve the same result as the previous one.

Under the Type bar write down (#) #-# or (000) 000-0000 (for US phone number format).

Next in the Number tab, under the Category section, select.

Then open up the Format Cells dialog box either through the Home tab or using the shortcut Ctrl+1.

in this case, it is the range of cells C5:C11. With this method, we have more flexibility in terms of modifying the format. Using the same dataset from above we can use a different formatting approach. Read More: : Excel Phone Number Format Not Working (4 Solutions)ġ.2 Formatting Cells as Custom Phone Number You can now see the phone numbers in area code format. In the Number tab, go to Special under Category and select Phone Number in the Type Then press OK.Then go to the dialog box launcher under the Number group in the Home A new Dialog box, Format Cells, will appear (you can also access this by pressing Ctrl+1 for a shortcut).In this case, it is the range of cells C5: C11.

First, select the cells, you want to modify.

We can format it by specific country’s phone number format from the Format Cells option. Formatting Cells to Write Phone Numberįor this set of methods, I have selected the following dataset, which includes each person’s name and phone number.Īs we can see above, Excel enters a phone number as a series of numbers. In this article, we will go through each method one by one. We can categorize all the methods in two sub-sections: formatting cells and using functions.

Excel number format dialog box launcher