Microsoft Office Professional 2010 Step by Step eBook

330 Chapter 11 Change Workbook Appearance

Important You need to enclose any text to be displayed as part of the format in quotes so

that Excel recognizes the text as a string to be displayed in the cell.

In this exercise, you’ll assign date, phone number, and currency formats to ranges of cells.

SET UP You need the ExecutiveSearch_start workbook located in your Chapter11

practice file folder to complete this exercise. Open the ExecutiveSearch_start

workbook, and save it as ExecutiveSearch. Then follow the steps.

1. Click cell A3.


2. On the Home tab, click the Font dialog box launcher.

The Format Cells dialog box opens.

3. If necessary, click the Number tab.


4. In the Category list, click Date.

The Type list appears with a list of date formats.

The Type list displays date formats that are specific to the location selected in the Locale list.

5. In the Type list, click 3/14/01.


6. Click OK to assign the chosen format to the cell.

Excel displays the contents of cell A3 to reflect the new format.