If you are working with several currencies in an Excel worksheet, you will need to change the currency symbol. This article will show you how to change Excel’s default currency. Here, I will show you 2 handy ways to change currency symbol in Excel.
Download Practice Workbook
You can download the following practice workbook that we have used to prepare this article
2 Handy Ways to Change Currency Symbol in Excel
Here is an Employee List that contains three columns: ID, Name, and Monthly Salary. A dollar sign ($) appears in the Monthly Salary column. Dollar signs are Excel’s default currency symbols. In this article, we will demonstrate 2 easy and simple methods to change currency symbol in Excel. This was done using Excel 365. Any version of Excel will do the same.
1. Choose a Different Currency Symbol from Format Cells Window
By selecting the cells you want to change, you can change some of the currency numbers to Euros. Follow the steps below to do this.
- To begin with, select the cells (D5:12), then go to the Home tab >> Number >> click on the arrow sign as shown in the following image. A Format Cells dialog box will pop up.
- At this point, under the Number section, choose the Currency option. Then, click on the drop-down mark of the Symbol box. Search for the Euro and, then click OK.
Here is the output.
In another way, you can easily change the currency symbol. Just select the cells (D5:12) >> go to the Home tab >> Number >> click on the drop-down list that has a currency symbol on it. Finally, select Euro from the drop-down list.
Finally, here is the result. However, this time the result is in the Accounting format.
Read More: List of Currency Symbols in Excel
2. Change Format in Windows Clock and Region Settings to Change Default Currency Symbol
In this method, you will learn to change currency symbols by changing regions in your operating system. Just follow the steps below to change the currency symbol in Excel.
- First, in the windows search box, search for the Control Panel, and click on it. A Control Panel window will pop up.
- Now, click on the Change date, time, or number formats option. A Region dialog box will appear.
- Under the Format section, click on the drop-down mark (down arrow) of the Format box. Search for the region of which currency you need. In this example, we choose the Japanese (Japan).
- Next, click on Apply first, then OK.
- At this point, please reopen the Excel file in which you need to change the currency symbol. After that, select the cells (D5:12), go to the Home tab >> Number >> click on the currency symbol as shown in the following image.
Finally here is the result that shows Japanese currency instead of Dollars.
Read More: How to Add Currency Symbol in Excel (6 Ways)
In this tutorial, I have discussed 2 handy ways to change currency symbol in Excel. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
- Convert Currency to Words in Excel (with Easy Steps)
- Currency with 2 Decimal Places in Excel (with Quick Steps)
- Difference Between Accounting and Currency Format in Excel
- Excel VBA: Format Currency to Two Decimal Places (3 Methods)
- Remove Currency Symbol in Excel (6 Ways)
- How to Concatenate and Keep Currency Format in Excel (3 Methods)