Table of Contents
This tip is about the how to Format Contact Numbers in MS Excel. So read this free guide, How to Format Contact Numbers in MS Excel. If you have query related to same article you may contact us.
How to Format Contact Numbers in MS Excel – Guide
formatting phone numbers in Excel are possible. It’s a small but very innovative feature in Excel. Each country has a different country code and writing format. phone numbers. some have phone numbers separated by spaces, some allow square brackets for the country code, some differ in the length of the number, and some put spaces after the country code, and the rest of the phone the number follows the order. Looking at an entire column of 12-digit numbers can make a reader’s eyes a little blurry, so it is always preferable to present these numbers in an easier-to-read format, especially if the numbers contain international and national codes.
In addition to the readability issue, there is the issue of automatic formatting. Suppose you have a phone number such as “01873548923”. After typing this number into a cell in an Excel spreadsheet and pressing Enter, the number is automatically formatted to “1873548923”.
formatting Phone numbers for embedded Excel format
Below are steps to format these phone numbers in Excel:
formatting Phone numbers to a custom format
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.
According to the ITU E.123 standard, a US telephone number must be specified in the format +1 XXX XXX XXXX for international contexts and (0XXX) XXX XXXX for local contexts. There’s also a pseudo format that blends in like: + XX (XXX) XXX XXXX Let’s see what your custom number format would look like for each of these forms:
As mentioned before, we add a slash (”) before the zero to 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
A landline number in India would have the format XXX-XXXXXXX, while a mobile number would have the format XXXXX-XXXXX. In international contexts, mobile numbers can be formatted as +91-XXXXX XXXXX. +91 represents India’s international access code. So your custom formats would be:
International and local code format for UK numbers
For the UK, number formatting is as follows:
Final note
I hope you like the guide How to Format Contact Numbers in MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.