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.
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.
- 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.
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.
- 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.
- 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.
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.
- Select Accounting from the drop-down menu.
- 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.
- Select More Number Formats from the drop-down menu.
- 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.
- 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.
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.
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.
- 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.
- Check how it looks if we add a currency symbol from the insert symbol option.
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.
- See what it looks like after adding the currency symbol with the Joining formula.
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.
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.
- 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.
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.
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.