Microsoft Excel 2007

Currency Symbols in Excel 2007

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 Ribbon bar (on the Home Tab):

Click the drop down list that says General. You'll then be presented with the 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:

Click OK to set the pound sign as the currency.

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

< -- Save your work in Excell 2007 | How to Merge a Cell -->

<--Back to the Excel 2007 Contents Page

View all our Home Study Computer Courses