Microsoft Office Tutorials and References
In Depth Information
Change Number Formats
Change Number Formats
You can use number formatting to control the appearance of numerical data in your worksheet. For
example, if you have a column of prices, you can format the data as numbers with dollar signs and
decimal points. If prices listed are in a currency other than dollars, you can indicate that as well.
Excel offers several different number categories, or styles, to choose from. These include Currency
styles, Accounting styles, Date styles, Time styles, Percentage styles, and more. You can apply
number formatting to single cells, ranges, columns, rows, or an entire worksheet.
Change Number Formats
1 Select the cell, range, or data
that you want to format.
2 Click the Home tab.
3 Click the Number Format
.
4 Click a number format.
Excel applies the number format to
the data.
A Click the Accounting Number Format
button ( ) to quickly apply dollar
signs to your data. Click the button’s
to specify a different currency
symbol, such as Euro.
B Click the Percent Style button ( )
to quickly apply percent signs to your
data.
C Click the Comma Style button (
) to
quickly display commas in your
number data.
D Click the dialog box launcher ( ) in
the Number group to open the Format
Cells dialog box and display additional
number-formatting options.
156
Search JabSto ::




Custom Search