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


<< Go Back to Accounting Number Format | Number Format | Learn Excel

What is ExcelDemy?

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

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo