Naimul Hasan Arif
There are a lot of variations in currencies. Throughout the whole wide 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.
Download Practice Workbook
4 Simple Ways to Change Accounting Format in Excel
1. Using Number Format Command from Home Tab
In order 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 1 in 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: [Fixed] Accounting Format in Excel Not Working (2 Quick Solutions)
2. Change in Accounting Format Applying Format Cells Command
After Right-click 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 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: Apply the Accounting Number Format to the Selected Cells in Excel
3. Keyboard Shortcut to Change Accounting Format
Keyboard Shortcut 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 3 in 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.
4. Utilizing Accounting Number Format Command from Ribbon
May be the simplest way to change the Accounting format is the employment of 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 More Accounting Formats… option.
Thus, we will have a Format Cells wizard.
- Then, edit the Decimal Places. Here, I have used 1 in Decimal Places option.
- After that, change 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.
Practice Section
For more expertise, you can practice here.
Conclusion
That’s all for the article. In this article, I have tried to elaborate on 4 simple ways to change Accounting format in Excel. It will be a great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.
