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.
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.
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.
- 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.
- 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.
After that, you will see the currency of the United States.
Thus, you can make the Accounting format in Excel work properly.
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.
In the following image, we have some numbers in the Text format with errors.
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.
- 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.
Thus, you can make the Excel Accounting format work by using the proper number format.
Read More: What is Accounting Number Format in Excel?
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.