Microsoft Office Tutorials and References
In Depth Information
Applying Number Formats
The values in the Yearly Sales worksheet are difﬁ cult to interpret. For example, it is
unclear whether a particular value represents sales revenue or units sold, and it is hard to
determine, without study, whether a revenue value is expressed in millions or hundreds
of thousands of dollars. You will format these values to make them easier to read.
To apply a thousands separator to the units sold values:
1. Select the range C7:E15 .
2. In the Number group on the Home tab, click the Comma Style button . Each
value in the selected range now includes a thousands separator. Two digits were
also added to the right of the decimal point. Because the units sold values are
expressed in integers, you will remove the digits to the right of the decimal place.
3. In the Number group, click the Decrease Decimal button
twice. The two extra
digits are removed. See Figure 2-9.
Units sold values formatted
Decrease Decimal button
negative values ar e displayed
within parenthese s
added to each value;
no digits appear to
the right of the
Though you used the Comma Style button to add the thousands separator, the button
actually applies an accounting style used for currency values to the values in the
columns. This accounting style lines up currency values within a column by the currency
symbol and decimal point. When the values do not have a currency symbol, the values
are aligned by the decimal point. The accounting style also encloses negative numbers,
such as –124 in cell E8, within parentheses, such as (124). This is a standard format used
in accounting documents. If you prefer to display negative numbers in a different way,
you can modify this format. Another standard accounting practice is to add a currency
symbol to only the ﬁ rst and last entries within a column of values.
You will display the revenue values in columns C through E using the same
accounting style, but with two decimal places and with the currency symbol appearing only in
rows 18 and 26.