How to Format Contact Numbers in MS Excel – Guide

To format phone numbers in Excel, you can use the following steps:

  1. Choose the column in which you want to format the numbers.
  2. Click on the Format button.
  3. In the Format field, enter a new country code and press ENTER.
  4. In the next field, enter a new phone number and press ENTER.
  5. Click on the OK button to finish formatting the numbers.

This number is automatically formatted to the international format of “0187”.

formatting Phone numbers for embedded Excel format

  1. Enter the phone numbers into a spreadsheet.
  2. Use the “Format Cells” option in Excel to change the format of the phone numbers.
  3. Save the spreadsheet as a .xls file. ..

Select the cell or range of cells you need to format.

  1. In the worksheet, select the cell or range of cells you need to format.
  2. On the Home tab, in the Styles group, click Format Cells.
  3. In the Format Cells dialog box, click Cell Formatting Options.
  4. In the Category list, under Number, click Decimal Places.
  5. Under Numbering Style, in the General category, select Two Digits After The Decimal Point (2dp).
  6. Click OK to close the Format Cells dialog box and return to your worksheet. ..

In the Home tab, you can select a number format from the formatting drop-down list. This includes more specific formats like percentages and decimals. ..

If you want to format cells in a table, right-click on the table and select “Format Cells” from the pop-up menu. ..

This will open the ‘Format Cells’ dialog. Select the ‘Number’ tab and from the list of categories select the ‘Special’ option.

The Type field on the right side of the dialog allows you to control how your text looks when it is displayed. You can choose between a number of different types of formatting, including bold, italic, underline, and strikeout.

To activate your new phone number, select the ‘Phone Option number in the list and click OK. ..

formatting Phone numbers to a custom format

Format the text in the cells in the following table.

Select the ‘More number formats’ drop-down list in the ‘Number’ group and select a format that you want to use for your data.

If you want to format cells in a table, right-click on the table and select “Format Cells” from the pop-up menu. ..

This will open the ‘Format Cells’ dialog. Select the ‘Number’ tab and from the list of categories select the ‘Custom’ option.

You can now choose a Type format from the right side of the dialog. For example, 0.00. The selected format appears in the Type input box. ..

000 .000 .0000

International and local code format for US numbers

Different countries have different conventions for writing phone numbers. There are international standards for phone number formats, such as those issued by the International Telecommunication Union. There are also different national telephone numbering plans, which vary from country to country.

+1 XXX XXX XXXX for international contexts and (0XXX) XXX XXXX for local contexts Let’s see what your custom number format would look like for each of these forms:

The general form for a phone number is +00 (000) 0000000.

For international contexts: ( 000) 0000000

For international contexts, the number 100000000000 is the global emergency response number.

The United States international access code is 1.

As mentioned before, we add a slash (”) before the national context form because we want Excel to see the first zero as a special character rather than a placeholder.

International and local code format for India

+91-XXXXX-XXXXX XXX-XXXXXXX ..

For mobile numbers in a local context, use the following format: 00000-00000.

The international context for mobile numbers is +91-00000000000.

International and local code format for UK numbers

1 2 3 4 5 6 7 8 9 10

For suburban areas: (0XXX) XXXX

For metropolitan areas: (0XXXX) XXXXXX or (0XXX XX) XXXX ..

For British contexts: +44 12 XXXX XXXXX

Final note

This guide will show you how to format contact numbers in Microsoft Excel. If you have any query about this article, you may ask us. Additionally, please share your love by sharing this article with your friends.