Look at the following spreadsheet, which you will be shortly creating:

Simple spreadsheet in Microsoft Excel

Simple spreadsheet in Microsoft Excel

 

The column D has a heading of “Price”. The all prices have the currency symbol. To insert the new currency symbol, highlighted the cells to change or insert currency symbol. With the cells highlighted, locate the Number panel on the Excel ribbon.

Number Panel in Microsoft Excel

Number Panel in Microsoft Excel

Drop down the black down arrow in ┬áthe currency option. List of option display to your screen. Click at the “General” for no specific format and for more option click on the “more number formats”, which is at the bottom of the window that has been displayed to the your screen.

Currency option in Microsoft Excel

Currency option in Microsoft Excel

By the clicking on more numbers format option, a new window will be displayed in front of you.In category list, click on currency and select a currency sign from the symbol list. The new window looks like this:

Currency window in Microsoft Excel

Currency window in Microsoft Excel

Select “Armenian” from the option and click OK to set as currency.

In the next tutorial, you will see how to merge cells in Microsoft Excel and they do not overlaps into another cells..

Please follow and like us:

admin

Leave a Reply

Your email address will not be published. Required fields are marked *