There are a lot of variations in currencies. Throughout the whole world, every country maintains a fixed currency. Sometimes, we face the necessity of changing the Accounting format while working on Microsoft Excel. In this article, I will try to elaborate on 4 simple ways to change the Accounting format in Excel. I hope it will be handy for all Excel users.
For more simplification, I am going to use a dataset of a company’s salary structure in the Name, Department, and Annual Salary columns.
1. Using Number Format Option to Change Accounting Format in Excel
To change the Accounting format in Excel, we can use the Number Format command from the Home tab. It is a very simple way to fulfill our purpose.
Steps:
- Select all the cells in which you want to change the Accounting format. Here, I have selected cells D5:D13.
- Go to the Home tab.
- Next, click on the Number Format button.
- Then, select the More Number Formats… option.
A Format Cells wizard will appear.
- You can edit the Decimal Places. Here, I have used the 1 in the Decimal Places option.
- Change the currency sign from the Symbol I selected the Russian currency.
- Finally, press OK to finish the process.
Thus, we can change the Accounting format in Excel.
Read More: How to Apply Accounting Number Format in Excel
2. Changing to Accounting Format with Format Cells Command in Excel
After right-clicking on the mouse, we can apply the Format Cells command to change the Accounting format.
Steps:
- Firstly, select all the cells that you want to modify. Here, I have selected cells D5:D13.
- Then, Right-click on the mouse.
- From the available options, click on the Format Cells option.
Then, a Format Cells wizard will appear.
- Edit the Decimal places. Here, I have used 0 in the Decimal places option.
- Next, change the currency sign from the Symbol I selected the Welsh currency.
- Finally, press OK to finish the process.
This is how we can fulfill our purpose.
Read More: How to Apply the Accounting Number Format to the Selected Cells in Excel
3. Keyboard Shortcut to Change Accounting Format
Using Keyboard Shortcuts is another way to change the Accounting format.
Steps:
- Firstly, select the cells that you want to convert. Here, I have selected cells D5:D13.
- Then, press CTRL + 1.
Then, a Format Cells wizard will appear.
- Edit in the Decimal Places Here, I have used the 3 in the Decimal Places option.
- Afterward, change the currency sign from the Symbol I selected the Dutch (Netherlands) currency.
- Finally, hit OK to finish the process.
We can quite easily fulfill our purpose with this process.
Read More: How to Convert Accounting Format to Number Format in Excel
4. Utilizing the Accounting Number Format Command from Ribbon
Maybe the simplest way to change the Accounting format is the employment of the Accounting Number Format option.
Steps:
- Select the cells that you want to convert. Here, I have selected cells D5:D13.
- Click on the Accounting Number Format from the Home tab.
- Select a currency that you prefer. I have chosen Chinese (China).
In this way, we can change the Accounting format in a simple way.
- For more modification, choose the More Accounting Formats… option.
Thus, we will have a Format Cells wizard.
- Then, edit the Decimal Places. Here, I have used the 1 in the Decimal Places option.
- After that, changed the currency sign from the Symbol I selected Azerbaijan (Cyrillic) currency.
- Finally, press OK to finish the process.
Thus, we can make further modifications to change the Accounting format.
Read More: How to Simultaneously Apply Accounting Number Format in Excel
Download Practice Workbook
Conclusion
That’s all for the article. In this article, I have tried to elaborate on 4 simple ways to change the accounting format in Excel. It would be a great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below.