How to Change Accounting Format in Excel?

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Change Accounting Format in

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.

How to Change Accounting Format in

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.

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 the 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: 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.

How to Change Accounting Format in

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.

How to Change Accounting Format in

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

How to Change Accounting Format in

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

  • For more modification, choose the 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 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.

How to Change Accounting Format in

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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif
Naimul Hasan Arif

Hello everyone, I am Naimul Hasan Arif, graduated from Bangladesh University of Engineering and Technology (BUET). I am working as an Excel and VBA Content Developer. I try to remain dedicated to my duties and give my best with my skills & knowledge.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo