To set the number format to a telephone number in Microsoft Excel, select the cell or range of cells you want to format, then go to the Home tab, click the Dialog Box Launcher in the Number group, choose Special from the Category list, and select Phone Number as the Type. This built-in format instantly displays numbers in a standard telephone layout, making your contact lists easier to read and dial.
How to set the number format to a telephone number in Microsoft Excel
Excel includes a dedicated phone number format that automatically applies parentheses, spaces, and hyphens to a column of digits. Follow these steps on the selected cell or range:
- On the Home tab, locate the Number group.
- Click the Dialog Box Launcher (the small arrow in the bottom-right corner of the group).
- In the Format Cells dialog, select Special from the Category list.
- Choose Phone Number from the Type list. After selecting it, you can further customize it by adjusting decimal places, currency symbols, or other formatting options.
- Click OK to apply the format to the selected cells.
This formatting is cell-based, meaning it only affects the cells you selected, not the entire sheet. If the Phone Number option does not appear in the Special list, your locale may not include it by default; in that case, use the custom format method below.
Using a custom telephone number format in Excel
When the built-in Phone Number type is unavailable or you need a different layout, create a custom format:
- Select the cells you want to format.
- On the Home tab, open the Number Format drop-down in the Number group.
- Choose More Number Formats at the bottom of the list.
- In the Format Cells dialog, select Custom from the Category list.
- In the Type box, enter a pattern such as (000) 000-0000 for a ten-digit North American number.
- Click OK to apply.
You can adjust the pattern to include international calling codes and dialing prefixes, for example by adding a plus sign and country code before the area code, such as +1 (000) 000-0000 for the United States. This custom method works regardless of locale and gives you full control over the display.
What about Google Sheets and other devices?
At the time of writing, official documentation for a built-in phone number format in Google Sheets, iPhone, or Android was not available. Google Sheets does not provide a dedicated telephone number type in its number formatting menu, and no official Apple or Google support page documents a system setting called “number format to a telephone number” for the phone app or device settings. For Google Sheets, the specific menu path is Format → Number → More Formats → Custom number format, and a standard US telephone number pattern is "###-###-####" to display numbers in the familiar (###) ###-#### format. Third-party workarounds exist, but they are not verified by official sources and should be tested carefully. If you need to format phone numbers on those platforms, verify the latest official help pages before relying on any method.
Frequently Asked Questions
Will the phone number format in Excel change the actual value of the cell?
No. The format only changes how the number is displayed. The underlying value remains a plain number, so formulas and calculations that reference the cell will still work with the original digits.
Can I apply the phone number format to an entire column at once?
Yes. Select the entire column by clicking its letter header, then follow the same steps for the built-in or custom format. All existing and future numbers entered in that column will appear in the chosen telephone format.
What if my phone numbers include an extension?
The built-in Phone Number format does not support extensions. Use a custom format like (000) 000-0000 x0000 to include an extension, or keep the extension in a separate column for clarity.
Does the custom format work with numbers shorter or longer than ten digits?
Yes. You can design a pattern that matches your data. For example, use 000-0000 for seven-digit local numbers or +00 00 0000 0000 for international formats. The zeros act as placeholders for each digit.
Why is the Phone Number option missing from my Excel Special list?
The built-in phone number type is tied to certain locales. If it is missing, switch to the custom format method described above, which works in all regional versions of Excel.
Why is it important to set the number format to a telephone number?
It ensures phone numbers are displayed in a recognizable and user-friendly format, making it easier to read and dial correctly.
Will setting the number format to a telephone number affect how my contacts' numbers are displayed?
Yes, it can ensure all phone numbers are uniformly formatted for consistency and ease of use in your device's address book or contact list.
Are there different number formats for telephone numbers in different countries?
Yes, it's important to be aware of specific conventions and formats used in different regions to ensure accurate formatting according to local standards.
