Formating as Currency

As our spreadsheet is all about dollars we will format the numbers using the currency style.

Exercise

[] Select, with the mouse, all of the cells that contain numbers.

[] Select the Format - Cells - Number menu option.

[] Select the CURRENCY entry and press OK

Note that a dollar sign has appeared in each cell and that each cell now has two decimal places and commas to separate the thousands from the hundreds.

Also some of the entries have turned into # signs.

This indicates we need a wider column to correctly display the cell contents.