How to Change Accounting Format in Excel (4 Simple Ways)

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.

How to Change Accounting Format in


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.

How to Change Accounting Format in

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.

How to Change Accounting Format in

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

How to Change Accounting Format in

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.

How to Change Accounting Format in

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.

How to Change Accounting Format in


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

How to Change Accounting Format in

In this way, we can change the Accounting format in a simple way.

  • For more modification, choose More Accounting Formats… option.

How to Change Accounting Format

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.

How to Change Accounting Format in


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.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo