Microsoft Office Tutorials and References
In Depth Information
Using keyboard shortcuts to format numbers
When you need more control over number formats, use the Number tab of the Format Cells
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 and click the dialog box launcher in the lower-right corner of the
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.
■ Press Ctrl+1.
The Number tab of the Format Cells dialog box displays 12 categories of number formats.
When you select a category from the list box, the right side of the tab changes to display
options appropriate to that category.
The Number category has three options that you can control: the number of decimal places
displayed, whether to use a thousands separator, and how you want negative numbers
displayed. Notice that the Negative Numbers list box has four choices (two of which display
negative values in red), and the choices change depending on the number of decimal places
and whether you choose to separate thousands.
The top of the tab displays a sample of how the active cell will appear with the selected
number format (visible only if a cell with a value is selected). After you make your choices,
click OK to apply the number format to all the selected cells.