Microsoft Office Tutorials and References
In Depth Information
Number
Table 11-4 Keyboard Shortcuts for Common Number Formats
Shortcut
Action
Ctrl+~ (tilde)
Applies the General number format
Ctrl+Shift+1
Ctrl+!
Applies the Number format with two decimal places, a 1000 separator,
and a minus sign (–) for negative values
Ctrl+Shift+2
Ctrl+@
Applies the Time format with the hour and minute, followed by AM or
PM (11:30 AM)
Ctrl+Shift+3
Ctrl+#
Applies the Date format with the day, month (abbreviated), and year
(31-Jan-11)
Ctrl+Shift+4
Ctrl+$
Applies the Currency format with default currency symbol, two
decimal places, and negative values in parentheses
Ctrl+Shift+5
Ctrl+%
Applies the Percentage format with no decimal places
Ctrl+Shift+6
Ctrl+^
Applies the Scientific number format with two decimal places
The most useful Excel keyboard shortcut of all, in our opinion, is Ctrl+1. Pressing that
combination opens the Format Cells dialog box and selects the Number tab. In the remainder
of this section, we look in detail at each of the available formatting options in the Format
Cells dialog box.
Number
If you enter a number and use a comma to set off thousands, Excel applies the Number
format using the default thousands separator for the region and language as defined in
Windows. If the number you enter contains more than two decimal places, Excel stores the
exact number you entered but rounds it for display purposes to no more than two decimal
places.
Use the Increase Decimal and Decrease Decimal commands (in the Number group on the
Home tab) to add or subtract one decimal place at a time from the selection.
To manually set options for the Number format, make a selection and then open the
Format Cells dialog box. Figure 11-8 shows which settings are available.
Search JabSto ::




Custom Search