Microsoft Office Tutorials and References
In Depth Information
Using keyboard shortcuts to format numbers
The Number Format drop-down list contains several common number formats. Additional
options include an Accounting Number Format drop-down list (to select a currency
format), a Percent Style button, and a Comma Style button. The group also contains a button
to increase the number of decimal places, and another to decrease the number of decimal
places.
When you select one of these controls, the active cell takes on the specifi ed number
format. You also can select a range of cells (or even an entire row or column) before clicking
these buttons. If you select more than one cell, Excel applies the number format to all the
selected cells.
Using keyboard shortcuts to format numbers
Another way to apply number formatting is to use keyboard shortcuts. Table 13.1
summarizes the keyboard shortcut combinations that you can use to apply common number
formatting to the selected cells or range. Notice that these Ctrl+Shift characters are all located
together, in the upper left of your keyboard.
TABLE 13.1 Number Formatting Keyboard Shortcuts
Key Combination
Formatting Applied
13
Ctrl+Shift+~
General number format (that is, unformatted values)
Ctrl+Shift+$
Currency format with two decimal places (negative numbers appear in
parentheses)
Ctrl+Shift+%
Percentage format, with no decimal places
Ctrl+Shift+^
Scientifi c notation number format, with two decimal places
Ctrl+Shift+#
Date format with the day, month, and year
Ctrl+Shift+@
Time format with the hour, minute, and AM or PM
Ctrl+Shift+!
Two decimal places, thousands separator, and a hyphen for negative
values
Formatting numbers 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 fi ne. 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, shown in Figure 13.14. For formatting numbers, you need to use the
Number tab.
Search JabSto ::




Custom Search