Currency Symbols in Excel

Take a look at the following spreadsheet, which you'll shortly be creating:

The C column has a heading of "Price Each". The prices all have the currency symbol. To insert the currency symbol, do this:

• Enter some prices on a spreadsheet (any will do), and highlight the cells
• With the cells highlighted, locate the Number panel on the Excel 2007/2010 Ribbon bar (on the Home Tab):

Click the drop down list that says General. You'll then be presented with a list of options:

Click the Currency item to add a pound sign. But if you're not in the UK, you'll see the default currency for your country.

To see other currencies, click on More. The Format Cells dialogue box appears. In the Category list, click on Currency. Select a Currency sign from the Symbol list. The dialogue box will then look like this:

In the next part, you'll see how to Merge Cells in Excel, so that they don't spill over into other cells. You'll need this for your Review.