Format Phone Numbers in Excel

How to Format Phone Numbers in Excel?

The formatting phone number in excel means changing the appearance of a phone number without changing the number itself. It helps us to transform the phone number, which is easier to read & understand.

There are two ways to format the phone number in excel:

  1. By right-clicking on the cell.
  2. From the Ribbon Tab in ExcelRibbon Tab In ExcelRibbons in Excel 2016 are designed to help you easily locate the command you want to use. Ribbons are organized into logical groups called Tabs, each of which has its own set of functions.read more.

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Format Phone Numbers in Excel (wallstreetmojo.com)

Let us learn the formatting of the phone number in excel with the help of a few examples.

You can download this Format Phone Numbers Excel Template here – Format Phone Numbers Excel Template

Example #1 – Format Phone Number to Zip Code + 4

We have data of the employee’s phone number of a company XYZ is available in general number format. Here, we will have to transform this data into an easily understandable form.

Steps to format the phone number in excel following form:

  1. Data of some phone numbers in a different format is shown below:

    Format Phone Number Example 1

  2. Now, Right-click on the cell, and you will get a list of items

    Format Phone Number Example 1-1

  3. Click on Format Cells option to format the number,

    Format Phone Number Example 1-2

  4. After clicking on the format cell in excel, you will again get a list, as shown in figure

    Format Phone Number Example 1-3

  5. Now from the list, click on Special option,

    Format Phone Number Example 1-4

  6. Click on the special option, and you will again get a pool of options

    Format Phone Number Example 1-5

  7. Now, click on ZIP Code+4 and then press the OK button in order to get the result after formatting, as shown in figure

    Format Phone Number Example 1-6

    Now let us learn with some more examples with multiple criteria.

Example #2 – Format Phone Number to Readable Phone Numbers

We have data of employee’s phone number of a company XYZ is available in general number format. Here, we will have to transform this data into an easily understandable form.

Steps to format the phone number in excel the following form:

Step #1 – Data of some phone numbers in a different format is shown below:

Format Phone Number Example 2

Step #2 – Now, Right-click on the cell, and you will get a list of items

Format Phone Number Example 2-1

Step #3 – Click on Format Cells Excel option to format the number,

Format Phone Number Example 2-2

Step #4 – After clicking on the format cell, you will again get a list, as shown in figure

Format Phone Number Example 2-3

Step #5 – Now from the list, click on Special option,

Format Phone Number Example 2-4

Step #6 – Click on the special option, and you will again get a pool of options

Format Phone Number Example 2-5

Step #7- Now, select the option “Phone number option” from the list, as shown in the figure.

Format Phone Number Example 2-6

Step #8 – Now, press the OK button in order to get the result after formatting, as shown in figure

Format Phone Number Example 2-7

Example #3 – Format Phone Number to Social Security Number

We have data of employee’s phone number of a company XYZ is available in general number format. Here, we will have to transform this data into an easily understandable form.

Steps to format the phone number in excel the following form:

Step #1 – Data of some phone numbers in a different format is shown below:

Format Phone Number Example 3

Step #2 – Now, Right-click on the cell, and you will get a list of items

Format Phone Number Example 3-1

Step #3 – Click on Format Cells option to format the number,

Format Phone Number Example 3-2

Step #4 – After clicking on the format cell, you will again get a list, as shown in figure

Format Phone Number Example 3-3

Step #5 – Now from the list, click on Special option,

Format Phone Number Example 3-4

Step #6 – Click on the special option, and you will again get a pool of options

Format Phone Number Example 3-5

Step #7 – Now, select the option “Social Security Number” from the list as shown in figure

Example 3-6

Step #8 – Now, press the OK button in order to get the result after formatting, as shown in figure

Example 3-7

Example#4 – Format Phone Number to Zip Code + 4, Readable Phone Number & Social Security Number

We have data of employee’s phone number of a company XYZ is available in general number format. Here, we will have to transform this data into an easily understandable form.

Steps to format the phone number in excel the following form:

Step #1 – Data of some phone numbers in a different format is shown below:

Example 4

Step #2 – Now, Right-click on the cell, and you will get a list of items

Example 4-1

Step #3 – Click on Format Cells option to format the number,

Example 4-2

Step #4 – After clicking on the format cell, you will again get a list, as shown in figure

Example 4-3

Step #5 – Now from the list, click on Special option,

Example 4-4

Step #6 – Click on the special option, and you will again get a pool of options

Example 4-6

Step #7 – Now, click on ZIP Code+4 / phone number / social security number as per the requirement and then press the OK button in order to get the result after formatting, as shown in the figure.

Example 4-7

Things to Remember 

There are a few things we need to remember while formatting phone numbers in excel:

  1. We need to be aware of the current format of the cell.
  2. Format painter copies the same formatting to another cell.

Recommended Articles

This has been a guide to Format Phone Numbers in Excel. Here we discuss how to Clean and Format Phone Numbers along with practical examples and downloadable templates. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Reader Interactions

Leave a Reply

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