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

Accounting Format in Excel Not Working: 2 Suitable Solutions

First, we will give two examples of the problems with the Accounting number 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 else 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 If Accounting Format Is Not Working

If you find that the Accounting format of your Excel workbook returns a 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 a 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.

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: How to Change Accounting Format in Excel

2. Using Proper Cell Format to Fix If Accounting Format Is 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.

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: How to Convert Accounting Format to Number Format in Excel

Download Practice Workbook


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.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Meraz Al Nahian
Meraz Al Nahian

Md. Meraz Al Nahian has worked with the ExcelDemy project for over 1.5 years. He wrote 140+ articles for ExcelDemy. He also solved a lot of user problems and worked on dashboards. He is interested in data analysis, advanced Excel, statistics, and dashboards. He also likes to explore various Excel and VBA applications. He completed his graduation in Electrical & Electronic Engineering from Bangladesh University of Engineering & Technology (BUET). He enjoys exploring Excel-related features to gain efficiency... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF