Page 165 - Excel 2013 All-in-One For Dummies

Group
Button Name
Accounting Number Format
Function
Opens a drop-down menu from which you can select the cur- rency symbol to be used in the Accounting number format. When you select the $ English (U.S) option, this format adds a dollar sign, uses commas to separate thousands, displays two decimal places, and encloses negative values in a closed pair of parentheses. Click the More Accounting Formats option to open the Number tab of the Format Cells dialog box where you can customize the number of decimal places and/or currency symbol used.
Formats your cell selection using the Percent Style number format, which multiplies the values by 100 and adds a percent sign with no decimal places.
Formats your cell selection with the Comma Style Number format, which uses commas to separate thousands, displays two decimal places, and encloses negative values in a closed pair of parentheses.
Adds a decimal place to the values in your cell selection.
Removes a decimal place from the values in your cell selection.
Hot Keys
Alt+HAN
Percent Style
Comma Style
Increase Decimal
Decrease Decimal
Alt+HP
Alt+HK
Alt+H0 (zero)
Alt+H9
Formatting Cells from the Ribbon 147
Don’t forget about the shortcut keys: Ctrl+B for toggling on and off bold in the cell selection, Ctrl+I for toggling on and off italics, and Ctrl+U for toggling on and off underlining for quickly adding or removing these attributes from the entries in the cell selection.
Book II Chapter 2
Formatting Worksheets