Microsoft Office Tutorials and References

In Depth Information

**Applying Number Formats**

◗

5.
In the Clipboard group on the Home tab, click the
Copy
button

. The range is

copied to the Clipboard.

◗

6.
Select the nonadjacent range
E8:F15;E18:F26
. You want to paste the formulas in

these cells.

◗

7.
In the Clipboard group, click the
Paste
button

. The formulas are pasted in the

selected ranges.

◗

8.
Click cell
to deselect the range. The formulas calculate the values for the net
A6

and percent increase in units sold and revenue from 2011 to 2012. See Figure 2-8.

Figure 2-8

Net and percent increase in sales and revenue

percent increase in sales from 2011 to 2012

increase in

sales from

2011 to 2012

increase in

revenue from

2011 to 2012

percent increase in revenue from 2011 to 2012

Applying Number Formats

You can format values using a
number format
, which displays the values in a way that

makes it easy for the reader to quickly understand and interpret them. You can change

the number format for the displayed value without affecting the underlying stored value.

Excel formats numbers by default in the
General number format
, which, for the most

part, displays values exactly as they are typed by the user. If the value is calculated from

a formula or function, Excel shows as many digits after the decimal point as will ﬁ t in the

cell with the last displayed digit rounded. Calculated values too large to ﬁ t into the cell

are displayed in scientiﬁ c notation.

The General number format is good for simple calculations, but some values require

additional formatting to make the numbers easier to interpret. Using Excel, you can:

• Set the number of digits displayed to the right of the decimal point

• Add commas to act as a thousands separator for large values

• Apply currency or accounting symbols to numeric values to identify the monetary unit

being used

• Display percentages using the % symbol