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 fi t in the
cell with the last displayed digit rounded. Calculated values too large to fi t into the cell
are displayed in scientifi 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
Search JabSto ::

Custom Search