Part I: Getting Started with Excel
Formatting numbers by using the Format Cells dialog box
In most cases, the number formats that are accessible from the Number group on the Home
tab are just fine. Sometimes, however, you want more control over how your values appear.
Excel offers a great deal of control over number formats through the use of the Format Cells
dialog box, as shown in Figure 2.10. For formatting numbers, you need to use the Number
tab.FIGURE 2.10
When you need more control over number formats, use the Number tab of the Format Cells
dialog box.You can bring up the Format Cells dialog box in several ways. Start by selecting the cell or
cells that you want to format and then do one of the following:■ Choose Home ➪ Number and click the small dialog box launcher icon (in the lower-
right corner of the Number group).
■ Choose Home ➪ Number, click the Number Format drop-down list, and choose More
Number Formats from the drop-down list.
■ Right-click the cell, and choose Format Cells from the shortcut menu.■ (^) P ress Ct rl+1.