Microsoft Office Tutorials and References
In Depth Information
Formatting Values: Making the Numbers Look Good
Either way, you’ll see the dialog shown in
Figure 5–55. Just click the desired choice.
Note that in the screenshot selection the
cells’ deletion would move the cells
currently in one column to the left
so that they become . You may
have to think about this one—or better yet,
experiment on a worksheet.
Figure 5–55. The Delete cells dialog box
NOTE: Deleting cells does exactly that—the command deletes entire cells, not just the contents
of the cells.
Formatting Values: Making the Numbers Look Good
Most of the work you’ll do with Excel will likely be numbers-based, and many of the
formatting options you need to know about impact numerical data only. Excel’s Number
button group (see Figure 5–56) contains a raft of ways to represent values that will make
your data more meaningful.
Figure 5–56. The Number button group
NOTE: Unlike the B, I, and U font format buttons, the first three buttons in the Number button
group (Accounting Number Format, Percent Style, and Comma Style) are not toggles—that is,
clicking any of these twice does not alternately turn their effects on and then off. We’ll get to
some ways you can remove them soon.
Turning Values into Currency
When you need to format numerical data so that it appears in currency form—dollars,
pounds, euros, or just about any other denomination you can think of—just go to what’s
called the Accounting Number Format option, represented by the button shown in Figure 5–57.
Search JabSto ::

Custom Search