Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.

Download Workbook

4 Methods to Change Default Currency in Excel

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

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


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

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


Similar Readings


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

Read More: Difference Between Accounting and Currency Format 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


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 know us in the comment section. Please visit our website Exceldemy to explore more.


Related Articles

Afia Kona

Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo