MULTI IN ONE: Currency Symbols in Excel

<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Take a look at the following spreadsheet, which you'll shortly be creating:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="A Spreadsheet in Excel 2007" border="1" height="201" src="http://www.homeandlearn.co.uk/excel2007/images/Review1.gif" width="336" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
The C column has a heading of "Price Each". The prices all have the currency symbol. To insert the currency symbol, do this:</div>
<ul style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<li>Enter some prices on a spreadsheet (any will do), and highlight the cells</li>
<li>With the cells highlighted, locate the <b>Number</b> panel on the Excel 2007 to 2013 Ribbon bar (on the <b>Home</b> Tab):</li>
</ul>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The Number Panel" height="87" src="http://www.homeandlearn.co.uk/excel2007/images/NumberPanel.gif" width="148" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Click the drop down list that says <b>General</b>. You'll then be presented with a list of options:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The Number Options" height="510" src="http://www.homeandlearn.co.uk/excel2007/images/NumberPanelList.gif" width="151" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
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.</div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
To see other currencies, click on <b>More</b> (or <b>More Number Formats</b> in Excel 2013).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:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Currency Options" border="1" height="277" src="http://www.homeandlearn.co.uk/excel2007/images/FormatCellsNumber.gif" width="442" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Click OK to set the pound sign as the currency.</div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<br /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
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.</div>
</div>

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". ...