Here, we will enter the new format for the phone number.
![adding a fx equation in excel mobile adding a fx equation in excel mobile](https://static.wixstatic.com/media/fb3a64_8ca14503190a4faf9b2d459132d4e49c~mv2.jpg)
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.
![adding a fx equation in excel mobile adding a fx equation in excel mobile](https://www.msofficeguru.info/wp-content/uploads/2015/12/autosum2.png)
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.
#Adding a fx equation in excel mobile code#
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. Once we click on Format cells, we will get a dialog box that contains different functions related to formatting a cell-like Number, Alignment, Font, Border, Fill, and Protection.Īs 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. Once we click on Format, we will get a drop-down list, from where we will select Format Cells which is located at the bottom of the list as shown below screenshot.
![adding a fx equation in excel mobile adding a fx equation in excel mobile](https://www.technewstoday.com/wp-content/uploads/2022/08/sum-option.jpg)
Now for formatting phone numbers in excel, first select phone numbers, then go to the Home menu and click on Format as shown below. We have phone numbers that have a length of 10 characters, as shown below. Let’s consider some random phone numbers for formatting them.
#Adding a fx equation in excel mobile download#
You can download this Format Phone Numbers Excel Template here – Format Phone Numbers Excel Template Example #1