How to Change Default Currency in Excel (4 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

If you want to change the default currency in Excel, this article will be helpful to you. Here, we will demonstrate to you 4 easy and effective methods that will help you to change default currency in Excel.


How to Change Default Currency in Excel: 4 Simple Methods

The following Employee List contains ID, Name and Salary columns. We can see in the Salary column that there is a dollar sign ($). This dollar sign is a default currency symbol in Excel. We will change this default currency by using 4 easy and simple methods. Here, we used Excel 365. You can use any available Excel version.

How to Change Default Currency in Excel


Method-1: Using Number Format Feature to Change Default Currency

Here, we will use the Number Format feature of Excel to change the default currency.

Steps:

➤ First, we will select the data of the Salary column > go to the Home tab > select the Number option > click on the Number Format which is a red colored marked down arrow.

How to Change Default Currency in Excel

A Format Cells window will appear.

We will see the Category is set to Currency and the Symbol is set as $ English (United States).

➤ After that, we will click on the down arrow of the Symbol box.

Here, we will see plenty of symbols. You can select your desired symbol from here. We want to select Japanese as our currency symbol.

➤ Then, we will select Japanese from the symbols > click OK.

Finally, we can see that the Salary column now holds the Japanese currency symbol.

How to Change Default Currency in Excel


Method-2: Use of Windows Settings Option to Change Default Currency

Here, we will use the Windows Setting option to change default currency in our Excel sheet.

In the following image, we can see that there is no currency symbol in our Salary column and we want to select a Japanese currency symbol for our Salary column.

How to Change Default Currency in Excel

Steps:

➤ Now, we will select the data of the Salary column > go to the Home tab > select Number option.

In the Number option, we will see the default currency is set to a dollar ($). We want to change this default currency.

How to Change Default Currency in Excel

➤ First, we will click on the Start button of the Windows.

➤ Afterwards, we will select the Settings App.

A Settings window will appear.

➤ After that, we will select Time & Language.

➤ Then, we will select Region.

A Region window will appear.

➤ Afterwards, we will select Additional date, time & regional settings.

A Clock and Region window will appear.

➤ Then, we will select Region.

A Region window will appear.

We can see the Format is set as English (United States).

➤ After that, we click on the down arrow of the Format box.

Now, we will see plenty of formats , and among them we will choose our desired format.

➤ Here, we selected the Japanese (Japan) format.

How to Change Default Currency in Excel

➤ After that, we will click on Apply > click OK.

Now, we will close the Region window and Settings window. We will go back to our Excel sheet.

➤ After that, we will select the data of the Salary column > go to the Home tab > select Number > click on the Accounting Number Format marked as red colored box.

Finally, we can see the Japanese currency symbol in the Salary column.

How to Change Default Currency in Excel


Method-3: Using Control Panel App to Change Default Currency

Here, we will change the default currency by using the Control Panel app.

Steps:

➤ First, we will go to the Start button of Windows.

How to Change Default Currency in Excel

➤ After that, we will select the Control Panel App.

A Control Panel window will appear.

➤ After that, we will select Clock and Region.

A Clock and Region window will appear.

➤ Afterwards, we will select Region.

A Region window will appear.

➤ After that, we will click on the down arrow of the Format box > select Japanese (Japan).

➤ Afterwards, we will click on Apply > click OK.

Now, we will close the Region and Settings window, and we will go to our Excel sheet.

➤ Afterwards, we will select the data of the Salary column > go to the Home tab > select Number > click on the Accounting Number Format marked as red colored box.

How to Change Default Currency in Excel

Finally, we can see the Japanese currency symbol in the Salary column.

How to Change Default Currency in Excel


Method-4: Employing Change the Way Currency Is Displayed Feature

This is a quick way to change default currency in Excel.

Steps:

➤ First, we will go to the Start button of Windows.

How to Change Default Currency in Excel

➤ After that, we will select Change the way currency is displayed.

A Region window will appear.

➤ After that, we will click on the down arrow of the Format box > select Japanese (Japan).

➤ Afterwards, we will click on Apply > click OK.

Now, we will close the Region window and go back to our Excel sheet.

➤ After that, we will select the data of the Salary column > go to the Home tab > select Number > click on the Accounting Number Format marked as red colored box.

Finally, we can see Japanese currency symbol in the Salary column.

How to Change Default Currency in Excel


Download Workbook


Conclusion

Here, we tried to show you 4 methods to change default currency in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to contact us in the comment section.


<< Go Back to Currency Conversion in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo