Microsoft Excel 2003: 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 highlight cells C6 through C19. Your screen should look like



Now point anywhere in the highlighted area and click the RIGHT mouse button. A pop-up menu will appear. Click-on Format Cells (like you have done before).


Click-on the Number “Tab” at the top of the Format Cells menu screen. 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 this occurs in your spreadsheet, go ahead and widen the columns as you did previously.



Your spreadsheet numbers should now look like the one above.