How to Change Currency Symbol in Excel (2 Handy Ways)

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.

2 Handy Ways to Change Currency Symbol in Excel


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.

Steps:

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

Use Number Format Feature to Change Currency Symbol in Excel

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

Use Number Format Feature to Change Currency Symbol in Excel

Here is the output.

Use Number Format Feature

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.

Use Number Format Feature to Change Currency Symbol in Excel

Finally, here is the result. However, this time the result is in the Accounting format.

Use Number Format Feature to Change Currency Symbol in Excel

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.

Steps:

  • First, in the windows search box, search for the Control Panel, and click on it. A Control Panel window will pop up.

Change Format in Windows Clock and Region Settings

  • Now, click on the Change date, time, or number formats option. A Region dialog box will appear.

Change Format in Windows Clock and Region Settings

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

Change Format in Windows Clock and Region Settings to Change Currency Symbol in Excel

  • Next, click on Apply first, then OK.

Change Format in Windows Clock and Region Settings to Change Currency Symbol in Excel

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

Change Format in Windows Clock and Region Settings

Finally here is the result that shows Japanese currency instead of Dollars.

Change Format in Windows Clock and Region Settings

Read More: How to Add Currency Symbol in Excel (6 Ways)


Conclusion

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.


Related Articles

Hafiz Islam
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo