How to Add Currency Symbol in Excel (6 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Add Currency Symbol in Excel


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.

Steps:

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

How to Add Currency Symbol in Excel

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.

Steps:

  • Select the values. Here, I selected the range D5:D9.
  • Click on the Editing sign beside the Number.

How to Add Currency Symbol in Excel

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.

How to Add Currency Symbol in Excel

Read More: [Solved]: Currency Format Not Working in Excel


2. Applying Accounting Format to Add Currency Symbol

We can also apply Accounting Format to add currency symbols.

Steps:

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

Steps:

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

How to Add Currency Symbol in Excel

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.

Steps:

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

How to Add Currency Symbol in Excel

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

How to Add Currency Symbol in Excel

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.

Steps:

  • Firstly, select the values. I have selected here the values in cells D5:D9.
  • Press CTRL + SHIFT + 4 at once.

How to Add Currency Symbol in Excel

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.

Steps:

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

How to Add Currency Symbol in Excel

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

How to Add Currency Symbol in Excel

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.

Steps:

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

How to Add Currency Symbol in Excel

  • Press ENTER and the currency symbol will be added in front of the result.

  • Then, use Fill Handle to AutoFill the rests.

How to Add Currency Symbol in Excel


Practice Section

You can practice here for the expertise.


Download Practice Workbook


Conclusion

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.


Related Articles

Naimul Hasan Arif
Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo