Microsoft Office Tutorials and References
In Depth Information
Applying Numeric Formatting
The Number group of the Home tab
offers tools for controlling how Excel displays—
you guessed it—numbers. From currency to
percentages, all the basic tools are here, as shown
in Figure 5-28.
Got money? A date or time? Use the Number
group of the Home tab to make your
numbers look like what they really are.
Pick a format for the cells in question.
To apply these formats to your numeric content,
select the cells to which the formatting should
apply, and then choose from the following
Number Format. This button displays the
default or current formatting in place for
the selected cells. If you click the button
arrow, a menu displays, as shown in Figure
5-29, offering eleven formatting options,
plus a More Number Formats command,
which opens the Format Cells dialog box to
the Number tab, as shown in Figure 5-30.
The Format Cells dialog box offers Number
formatting from 12 categories, each with
its own set of customization options.