As all currencies are not evaluated equally, sometimes it becomes a crying need to remark values with their currencies. In this article, I’m going to explain how to add currency symbol(s) in Excel.
For simplification, I am going to use a dataset on Prices of World Cup jerseys containing columns named Serial No, Team, and Price.
Add Currency Symbol in Excel: 6 Ways
1. Using Currency Format to Add Currency Symbol
We can easily add currency symbols by using Currency Format.
- Select all the values where we want to add a currency symbol. Here, I’ve chosen cells D5:D9.
- Next, select General from the Home tab.
- Choose Currency.
Then, Dollar signs($) will be added automatically to the selected values.
Excel, by default only supports Dollar Sign ($) but If you want to add other currency, you can follow the following steps.
- Select the values. Here, I selected the range D5:D9.
- Click on the Editing sign beside the Number.
A dialogue box named Format Cells will appear.
- Pick the Currency option.
- Choose your currency format from Decimal places and Symbol options. Here, I have chosen 3 decimal places and United Kingdom’s Currency symbol.
- Next, hit OK.
Finally, we have the currency symbol as Euro in front of the numbers.
2. Applying Accounting Format to Add Currency Symbol
We can also apply Accounting Format to add currency symbols.
- Select the values where we want to add the currency symbol. Here, I chose cells D5:D9.
- Next, go to the General from the Home tab.
- Pick Accounting Format.
Thus, we can have Dollar signs ($) for the selected values.
But you can change the number format as well as the currency symbol depending on your choice.
- Select the values that we want to modify. Here, I picked cells D5:D9.
- Press on the Editing sign beside the Number on the ribbon.
A dialogue box will appear.
- Choose Accounting.
- Then, pick your Format in Decimal places and Symbols. I picked 1 decimal place and chose Euro currency.
- Click OK.
The selected numbers will be formatted according to our given instructions.
3. Adding Currency Symbol Using Custom Format
The use of Custom format is another way to add currency symbols.
- Select the values to add the currency symbol. Here, I picked cells D5:D9.
- Go to the Home tab.
- Select the General option to edit.
- Next, select the More Number Formats option.
A dialogue box will appear.
- Go to Custom.
- Choose your Format. Here, I selected the format where the Dollar sign ($) will be added. The number will take 2 decimal places according to my instructions.
- Select OK.
Thus, the numbers will have a currency symbol.
Related Content: How to Change Currency Symbol in Excel
4. Applying Keyboard Shortcut to Add Currency Symbol
The quickest way to add a currency symbol is to use keyboard shortcut keys.
- Firstly, select the values. I have selected here the values in cells D5:D9.
- Press CTRL + SHIFT + 4 at once.
We can see the output on the screen. It adds Dollar Sign ($).
5. Inserting Character to Add Currency Symbol
We can add a currency symbol one by one by Inserting Currency Character.
- Double click on the selected cell and put the cursor where you want to add the currency symbol. Here, I picked cell D5 and put the cursor at the front of the number.
- Then, pick Insert from the ribbon.
- Next, go to Symbols and choose Symbol.
- Now, select the currency symbol you want to add. Here, I selected the Lira Sign.
- Then, click on ENTER.
The currency symbols will be added to the selected position.
6. Joining Formula with Currency Symbol to Add Currency
Joining Formula with the currency symbol is another way to add currency to the numbers.
- Select a cell and input the currency symbol after the equal sign in the formula.
- I selected cell F5 and typed the following formula.
="$ " & (D5*E5)
Here, I put the currency sign between the equal sign and the function where cell D5 and E5 is multiplied.
- Press ENTER and the currency symbol will be added in front of the result.
- Then, use Fill Handle to AutoFill the rests.
You can practice here for the expertise.
Download Practice Workbook
There are 6 ways shown on how to add currency symbol in Excel. Based on your choice, you can choose any method. For further queries, comment below.