- Click cell G3.
- On the Home tab, in the Number group, click the Number Format button’s down
arrow and then click More Number Formats. - If necessary, click the Number tab in the Format Cells dialog box.
- In the Category list, click Special.
The Type list appears with a list of special formats.
- In the Type list, click Phone Number, and then click OK.
Excel displays the contents of the cell as (425) 555-0102, matching the format you
selected, and the Format Cells dialog box closes.
- Click cell H3.
- Click the Font dialog box launcher.
- In the Format Cells dialog box that opens, click the Number tab.
- In the Category list, click Custom.
The contents of the Type list are updated to reflect your choice.
The Sample area displays a preview of the currently selected number format.
- In the Type list, click the #,##0 item.
Making Numbers Easier to Read 331