How to get a numbers underline in excel code#

Go to the Number tab and select the Custom option. After that same window of Format, cells will appear. To check whether our newly created format of phone numbers is actually visible in format cells or not, do right anywhere on the sheet and select Format Cells options from the bottom of the menu. Once our format is set, we can use it anywhere when we see phone numbers need to be formatted.

How to get a numbers underline in excel code#

Here we have separated the country code with brackets and divided half of the numbers with “-“ in 3 parts and click on OK as shown below.Īs we can see below, the format which we have set in Format Cells for phone numbers, it is now reflecting on the selected data. Here, we will enter the new format for the phone number. For that, remove/delete the text or numbers present in the type box, here we have deleted the word General to enter the new customized phone number format. Where we will find the type box, below it has the list of all customized number type, but not phone number format. Now go to the Custom option down at the Number tab. And select the Format Cells options as circled in the below screenshot.Īfter that, we will get the Format Cells dialog box as shown below. Now for formatting phone numbers, select the data first, then do right on it. Let’s consider the same sets of a sample phone number which we have seen in example-1. There is one more way of formatting phone numbers in Excel. Once we have formatted some test phone numbers, we can format any of the cell containing phone numbers in the same format. Once we click on OK, we will see the selected cells will get formatted according to the type we have fixed in the Format cell box, as shown below screenshot.

Once we do that, we will see that one of the selected cells with a phone number will also get “+91-” added just above to the formatted structure as a sample. As here, we deleted the word General from the type section and added “ +91” as the country code of India, followed by “-” and then 10 zeroes which are the standard 10 digit numbers. So for customizing the phone numbers, delete the already filled numbers or text and enter your own format.

As our task is to format the phone numbers, we will go into the Number tab and select the Custom option as circled in the below screenshot.Īs we can see and check by scrolling up and down the Type box, there is no predefined phone number format available.