[Fixed] Accounting Format in Excel Not Working (2 Quick Solutions)

The article will show you how to solve the issue of the accounting format in Excel not working properly. This may happen if your Operating System settings have a different regional format for time or currencies. There can also be other issues for the accounting format not working. Here in this article, I’ll discuss what kind of problem you may face while using the Excel accounting format and also the solution to that problem step by step.


Download Practice Workbook


2 Solutions to Problem with Accounting Format Not Working in Excel

First, we will give two examples of the problems with the accounting format not working. The accounting format is used to add a money symbol with numbers. If you use your Excel workbook in default settings, your numbers will be added with a dollar ($) symbol if you use the accounting format. But if you or someone changes the regional settings of your computer, applying the Accounting format won’t give you the result that you expect. For instance, look at the following picture. You will see that the numbers have the Pound (£) symbol because of the regional format.

accounting format in excel not working

Another scenario may happen if the cells are already in Text format. Even though you want to select the numbers in Text format and change that format to Accounting, it won’t change.

accounting format in excel not working

The article will simply show how to get rid of this inconvenience.


1. Changing Regional Format to Fix Accounting Format Not Working

If you find that the Accounting format of your Excel workbook returns the money symbol other than US dollars, it’s because your regional settings of the operating system are changed somehow. You can manually change the symbol by formatting numbers, but every time you open up a new workbook, you have to do this manually. Let’s go through the process for the permanent solution to the problem.

Steps:

  • First, go to your Time Settings at the right bottom corner of your Startup Menu or you can search for regional format in the Start menu and select it.

  • After that, you can see that on my laptop, the Regional format is in the United Kingdom And that’s why you saw the Accounting format was in Pound.

accounting format in excel not working

  • Now change the region according to your convenience. I chose the United States

  • Next, go to your Excel workbook and there you will see that the Accounting format now has the dollar symbol ($) by default. Just select it.

accounting format in excel not working

After that, you will see the currency of the United States.

Thus, you can make the Accounting format in Excel work properly.

Read More: Apply the Accounting Number Format to the Selected Cells in Excel


2. Using Proper Cell Format to Fix Accounting Format Not Working

Another reason for the Excel Accounting format not working could be the format of a cell or a range of cells. If a range of cells are already in the Text format and you put some numbers in it, you cannot convert them to Accounting format. Let’s go through the discussion below.

Steps:

In the following image, we have some numbers in the Text format with errors.

accounting format in excel not working

You cannot use these numbers for calculation. To format these numbers to Accounting,

  • First, select these numbers and then select the drop down icon that shows the error that occurred after applying an Excel command or formulas.
  • After that, select Convert to Number.

  • This operation will remove the error and convert these numbers from Text to Numbers.

accounting format in excel not working

  • Next, select these numbers and go to the drop down icon of the Number group.
  • After that, choose Accounting.

  • After that, you will see the numbers in proper Accounting format.

accounting format in excel not working

Thus, you can make the Excel Accounting format work by using the proper number format.

Read More: What is Accounting Number Format in Excel?


Conclusion

In the end, we can surmise that you will know what kind of problems you may face while working with the Accounting format and their solutions after reading this article. If you have faced any other kind of problem while using this format and also have better solutions or feedback, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy.


Related Articles

Nahian

Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo