Display numbers as phone numbers in Excel

Synopsis

Excel provides a special number format that lets you format a number as a phone number. For example, you can format a 10-digit number, such as 5555551234, as (555) 555-1234.

Solution

  1. Select the cell or range of cells that you want to format.

  2. On the Home tab, click the Dialog Box Launcher next to Number, or right click on the selected cells and select Format Cell...

    Dialog Box Launcher in Number group

  3. In the Category box, click Special.

  4. In the Type list, click Phone Number.

 

0 Comments

Article is closed for comments.