Microsoft Office Tutorials and References
In Depth Information
Formatting Numbers Using the Ribbon
3
Click the OK button to format the
dates in column C using the date
format style, mm/dd/yy.
Select cell E4 to deselect the
range C4:C13 (Figure 2–40).
Can I format an entire column
at once?
Yes. Rather than selecting the
range B4:B12 in Step 1, you could
have clicked the column B heading
immediately above cell B1, and
then clicked the Center button on
the Ribbon. In this case, all cells in
column B down to the last cell in
the worksheet would have been
formatted to use center alignment.
This same procedure could have
been used to format the dates in
column C.
Excel displays dates
in range C4:C12
using date style
format, mm/dd/yy
Figure 2–40
Other Ways
1. Right-click range, click
Format Cells on shortcut
menu, click appropriate
tab, click desired
format, click OK button
2. Press CTRL+1, click
appropriate tab, click
desired format,
click OK button
Formatting Numbers Using the Ribbon
As shown in Figure 2–30b on page EX 107, the worksheet is formatted to resemble
an accounting report. For example, in columns E through I, the numbers in the fi rst row
(row 4), the totals row (row 13), and the rows below the totals (rows 14 through 16) have
dollar signs, while the remaining numbers (rows 5 through 12) in columns E through I
do not.
To append a dollar sign to a number, you should use the Accounting number format.
Excel displays numbers using the Accounting number format with a dollar sign to the left
of the number, inserts a comma every three positions to the left of the decimal point, and
displays numbers to the nearest cent (hundredths place). Clicking the Accounting Number
Format button on the Ribbon assigns the desired Accounting number format. When you
use the Accounting Number Format button to assign the Accounting number format, Excel
displays a fi xed dollar sign to the far left in the cell, often with spaces between it and the fi rst
digit. To assign a fl oating dollar sign that appears immediately to the left of the fi rst digit
with no spaces, use the Currency style in the Format Cells dialog box.
The Comma style format is used to instruct Excel to display numbers with commas
and no dollar signs. The Comma style format , which can be assigned to a range of cells by
clicking the Comma Style button on the Ribbon, inserts a comma every three positions to
the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
Rotating and Shrinking
Entries in Cells
In addition to aligning
entries horizontally and
vertically, you also can
rotate and shrink entries
to fi t in a cell. To rotate
or shrink entries to fi t in
a cell, click Format Cells
on the shortcut menu,
click the Alignment tab
in the Format Cells dialog
box, and then select the
type of control you want.
 
 
Search JabSto ::




Custom Search