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.
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.
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.
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.
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.
➤ 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.
➤ 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.
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.
➤ 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.
Finally, we can see the Japanese currency symbol in the Salary column.
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.
➤ 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.
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
Get FREE Advanced Excel Exercises with Solutions!
