Skip to content Skip to main navigation Skip to footer

How to add currency symbol in Excel

How to add currency symbol in excel

When you are working with accounting numbers in Microsoft Excel you must format numbers as currency. To display numbers as monetary values, you must format those numbers as currency. Microsoft Excel has a fantastic feature to do this with a click only. If you are searching for how to add currency symbol in Excel your search goes to an end. This content will guide you to add currency symbols in Excel.

For better understanding, I have prepared a small data sheet on the price of rice in different countries which contains three columns named Serial, Country and price. I hope, this will make our tutorial more user-friendly.

Add currency symbol in excel_01

Different ways to add a currency symbol in Excel

Using currency format

  • Select the cell or range of cells you want to add a currency symbol.
  • Go to the Home tab, Number group. The number group is marked yellow in the below screenshot.

Add currency symbol in excel_02

  • Select Currency from the drop-down menu.

  • USD symbol ($) will be added by default to the range of cells you want to add to the currency symbol.

Add currency symbol in excel_04

But if you want to change the default currency symbol in excel to other countries follow the below instructions.

  • Select the range of cells you want to change the currency symbol.
  • Go to the Number group again and click the properties symbol as marked in the below screenshot.

Change currency symbol in excel_05

  • From the Format cells dialog box, go to the Number tab. Select the category as currency, decimal places as you need and symbol from the drop-down box.

Add currency symbol in excel_06

  • The same dialog box you can get by selecting Format Cells after right-clicking to any cell or range of cells.
  • Click OK to complete the job. Check the range of cell currency symbols.

symbol changed to euro

Accounting format to add a currency symbol

We can also use accounting format to add currency symbols. To perform this action please follow the below instructions:

  • Select the cell or range of cells you want to add a currency symbol.
  • Go to the Home tab, Number group. The number group is marked yellow in the below screenshot.

Add currency symbol in excel_02

  • Select Accounting from the drop-down menu.

Add currency symbol in excel_08

  • Thus we can get the accounting value.
  • If you want to change the default currency symbol in excel to other countries follow the below instructions.

Read More: How to print large excel sheet on one page

Using Custom number format

  • Select the cell or range of cells you want to add a currency symbol.
  • Go to the Home tab, Number group. The number group is marked yellow in the below screenshot.

Add currency symbol in excel_02

  • Select More Number Formats from the drop-down menu.

More number formats

  • From the Format cells dialog box, go to the Number tab. Select Custom. I have selected the custom format where the USD ($) sign with two decimal places will be added.

custom format to add $ sign

  • The same dialog box you can get by selecting Format Cells after right-clicking to any cell or range of cells.
  • Click OK to complete the job. Check the range of cell currency symbols.

Add currency symbol in excel_04

Read More: How to write vertically in Excel

Keyboard Shortcut to add a currency symbol

You can use the keyboard shortcut to add currency to a cell or range of cells.

  • Select the cell or range of cells you want to add a currency symbol.
  • Press Ctrl+Shift+4 together to add USD symbol ($) to the cell or range of cells.
  • Check the range of cell currency symbols below.Add currency symbol in excel_04

Insert a Character symbol to add a currency symbol

It is the most manual method to add a symbol. It is functional to add a currency symbol.

  • Go to the Symbols group under the Insert tab from the ribbon.

Manual Symbol

  • Double-click your cell where you want to insert the symbol and click Symbol from the ribbon. A symbol list will appear. Select the USD sign from there ($) and click insert to add the currency symbol to the cell.

Inser symbol

  • Check how it looks if we add a currency symbol from the insert symbol option.Add currency symbol in excel_04

Joining formula with currency symbol

It is also a manual method. It is functional to add a currency symbol.

  • Select the cell and type the following formula to add a currency symbol. For F5 cell I typed below formula.

=”$”&”4.09″
  • See what it looks like after adding the currency symbol with the Joining formula.Add currency symbol in excel_04

What is the difference between Currency and Accounting format?

Both currency and accounting formats are used to display the monetary values of a cell but still, there are some differences. The difference between the two formats are explained below:

Currency format: The currency symbol appears right next to the first digit in the cell. Decimal places, zero, and negative values are displayed in the below table.

Accounting format: Like currency format, Accounting format is also used for the monetary values of a cell. The currency symbol appears at the start of the cell and numeric values with decimal places at the end. Decimal places, zero, and negative values are displayed in the below table.

Difference between currency and Accounting format

how do I remove the currency symbol in Excel

After adding a currency symbol to a cell or a range of cells you may need to remove the currency symbol. No worries, it is a very simple task to do. There are two different ways to do this.

First Method: Format cells method

  • Select a cell or a range of cells from where you want to remove the currency symbol and right-click to select Format cells.

Format Cells

  • Go to the Number tab, Select General from the category and click OK to remove the currency symbol from the cell or range of cells.

remove currency symbols

First Method: From the Number group in the ribbon

  • Select the cell or range of cells you want to remove the currency symbol.
  • Go to the Home tab, Number group.
  • Select General to remove the currency symbol.

select general

Dear Learner, I hope, you already understood how to add currency symbols in Excel reading this content. If you have any queries please make comment below. I will try my best to reply to your comment as soon as possible.

0 Comments

There are no comments yet

Leave a comment

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