Formatting an In-Country or International Telephone Number

Excel

To format a telephone number, select the cells, then right-click and choose Format Cells. In the Format Cells dialog box, select Special in the Category list, then select Phone Number and choose Ok.

If you want to create a format for international dialing, then create a custom format with this pattern,

International Direct Dialing + Country Code + Area Code + Phone Number

The custom format is,

### ## ## #### ####

So dialing out of the US to Mumbai, India would look like,

011 91 22 5555 1212

The International Direct Dialing number is used to call out of the country you are in. The Country Code specifies the country you are calling into. You can find the IDD and country codes here,

IDD

http://www.distanto.com/international-direct-dialing-idd-prefixes.html

Country Code

http://countrycode.org/

Share the power...