Microsoft Office Tutorials and References
In Depth Information
Fig. 1.14
Final Result of Printing an Excel Spreadsheet
Before you leave this chapter, let’s practice changing the format of the figures
on a spreadsheet with two examples: (1) using two decimal places for figures that
are dollar amounts, and (2) using three decimal places for figures.
Close your spreadsheet by: File/Close, and open a blank Excel spreadsheet by
using File/New/Create (on the far right of your screen).
1.7 Formatting Numbers in Currency Format
(2 Decimal Places)
Objective: To change the format of figures to dollar format with two decimal
places
A3:
Price
A4:
1.25
A5:
3.45
A6:
12.95
Home
Highlight cells A4:A6 by left-clicking your mouse on A4 and dragging it down so
that these three cells are highlighted in a darker color
Number (top center of screen: click on the down arrow on the right; see Fig. 1.15 )
Search JabSto ::




Custom Search