Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1

  1. Click cell G3.

  2. On the Home tab, in the Number group, click the Number Format button’s down
    arrow and then click More Number Formats.

  3. If necessary, click the Number tab in the Format Cells dialog box.

  4. In the Category list, click Special.


The Type list appears with a list of special formats.


  1. 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.


  1. Click cell H3.

  2. Click the Font dialog box launcher.

  3. In the Format Cells dialog box that opens, click the Number tab.

  4. 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.


  1. In the Type list, click the #,##0 item.


Making Numbers Easier to Read 331

Free download pdf