Microsoft Office Tutorials and References
In Depth Information
EX 116
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
3
Click cell E4.
While holding down the CTRL key,
select cell G4.
Increase Decimal
button
Decrease Decimal
button
Click the Increase Decimal button
on the Ribbon to increase the
number of decimal places
displayed in cell E4 and G4.
Excel displays
numbers to three
decimal places
Select the range E5:E12. While
holding down the CTRL key, select
the range G5:G12.
Click the Increase Decimal button on
the Ribbon to increase the
number of decimal places displayed in
selected ranges (Figure 2–43).
What is the effect of clicking the
Increase Decimal button?
The Increase Decimal button
instructs Excel to display additional decimal places in a cell. Each time you click the Increase Decimal button, Excel adds
a decimal place to the selected cell.
Figure 2–43
To Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells
Dialog Box
The following steps use the Format Cells dialog box to apply the Currency style format with a fl oating dollar
sign to the numbers in the ranges E14:I16.
1
Select the range E14:I16 and
then point to the Format Cells:
Number Dialog Box Launcher on
the Ribbon (Figure 2–44).
Format Cells: Number
Dialog Box Launcher
Enhanced ScreenTip
range E14:I16
selected
Figure 2–44
C6161_EXC_02.4c.indd 116
C6161_EXC_02.4c.indd 116
3/6/07 3:29:02 PM
3/6/07 3:29:02 PM
 
Search JabSto ::




Custom Search