How to Add Currency in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Add Currency in Excel



In this tutorial, you will learn how to add currency in excel for numeric data. Briefly, this thing can be done by utilizing the Number Format menu in the spreadsheet.


Why do We Need to Learn How to Add Currency in Excel?


In the data processing which is related to money calculation, often we need to add currency in every number which represents a sum of money so the data interface can fit much better to the context and it can be easier to recognize the data type. This is sometimes important to do so it is clear that the data which we are processing and the result of the processing are numbers that are related to finance.

The clearest example in work for this practice might be in the accounting division of a company. In this division, the data which is most often processed is, of course, related to the core function of this division which is financial and money-related. If we often use spreadsheets in the data processing of this division, then it will be better if the data interface for the processing and the result of it is shown in the currency form. This, of course, will make the data easier to look at and also it will make it easier for other people to read it when the data is needed to be used as a consideration factor for a policy making that will impact heavily to the financial condition of the company.

Maybe we think of adding the symbol manually to each of our financial number data. But this will be very troublesome if the data is much. The symbol text manual addition will also change the data type to text and thus, the numbers cannot be calculated directly with other numbers in the spreadsheet. This is because calculations that uses text data type will result in an error.

To help to solve this need, then there is a number format conversion function that you can use in excel. This conversion function can be used into many cells at once. For sure, this will save time and make it easier for you to process the numbers in each cell as you need. Understanding how to add currency in excel is very useful if you need to deal with data which is related to money in a particular spreadsheet.


What is How to Add Currency Symbol in Excel?


How to add currency symbol in excel is a spreadsheet function to add currency symbol into a numeric data in a cell by changing its number format. The change of the format is done by using the Number Format function in this software.


How to Insert Currency in Excel?


The following will explain the step-by-step of how to add currency in excel. The approach given is by using Number Format function in the Home tab of this software or by the Format Cells menu when you right-click on a cell.


How to Add Currency in Excel

  1. Highlight the cell where the number to be converted is in

    How to Add Currency in Excel - Screenshot of Step 1

  2. Right-click on the cell and click Format Cells… or click Number Format Dropbox in the Home tab and choose More Number Formats

    How to Add Currency in Excel - Screenshot of Step 2-1

    How to Add Currency in Excel - Screenshot of Step 2-2

  3. Highlight Currency or Accounting

    How to Add Currency in Excel - Screenshot of Step 3

  4. Choose Rp in the Symbol dropdown

    How to Add Currency in Excel - Screenshot of Step 4

  5. Adjust the Decimal Places as you desire for the number

    How to Add Currency in Excel - Screenshot of Step 5

  6. Click Ok

    How to Add Currency in Excel - Screenshot of Step 6

  7. The process is done!

    How to Add Currency in Excel - Screenshot of Step 7



Exercise


After you have learned how to add currency in excel into your number data, now is the time you do the following exercise to sharpen your understanding!

Download the exercise file and work on the instructions. Download the answer key file if you have done the exercise and want to check your answer or if you are confused about how to do the instructions.

Link for the exercise file:
Download here

Instructions: Practice what you have already learned in the tutorial into each of the numbers. Pay attention to the particular instruction in each number
  1. Add into the first number using Currency format! What is the result?
  2. Add into the second number using Accounting format! What is the result?
  3. Change the empty cell format in the third row using one of the two formats and adjust it to two decimal digit. Then fill in the cell with 100000!

Link for the answer key file:
Download here


Additional Note


The choice between accounting or currency for the cell format has a difference in the placement of the symbol produced. Currency will place it in front of the number while Accounting will place it in the most left location in the cell.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert