|
MORE CELL FORMATTING
We want our numbers to look better. To do this
we'll include dollar signs and decimal points in our numbers.
This is done by using the mouse. Point to cell C6, hold down
the left mouse button and drag down slowly to high light
cells C6 through C19. Your screen should look like the one below.
Now point anywhere in the highlighted area and
click the right mouse button. A pop-up menu will appear.
Click-on Format Cells.
Click-on the Number (this is what you want) "Tab"
at the top of the window. Point to Currency and click-on
Currency.
Notice several things. The right side shows the number
of decimal places. The 2 is the default for cents. We'll
use 2. Notice above the Decimal Places that there is a sample
of what our number will look like. At the lower right it
shows how negative numbers can appear, depending on your
choice. When a negative number is calculated, it will appear
with your choice. Now click-on OK. All the numbers now have
$. If you have large numbers that are "too wide"
for the current column width you will see some ######## in
the cells where these numbers are located. If you need to, go ahead
and widen the columns as you did previously.
Your spreadsheet numbers should now look like the one on the
left.
|