Microsoft Office Tutorials and References
In Depth Information
To customize the format, click in the Type box and add any symbols or text you want to
the format. For example, typing a dollar ($) sign to the left of the existing format and then
typing “per month” (including quote marks) to the right of the existing format causes the
number 1500 to be displayed as $1500.00 per month .
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 Chapter04
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.
5. In the Type list, click 3/14/01 .