![]() 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. #Easy numbering xcel codeAs 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. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |