When we work in Excel, some of the data are in Accounting format, and we may want it to display in number format. It’s quite easy, and Excel has different options to do that. Here, we will show five quick methods to convert accounting format to number format in Excel.
How to Convert Accounting Format to Number Format in Excel: 5 Easy Ways
To demonstrate the methods to convert accounting format to number format, we have included a dataset that includes some numbers in accounting format. In accounting format, a Currency Sign is attached with the numbers. Also, negative numbers are inside the parenthesis. We will change the format to Number Format following different methods in the following sections.
1. Use Number Format from Ribbon to Change Accounting Format in Excel
Excel ribbon has quite many options. We will use the Number Format option to change the accounting format to the number format. Follow the given steps.
- First, select the range of data that is in accounting format.
- We selected the range C4:C10.
- Afterward, go to the Home tab in the ribbon and click on the small expansion icon beside the Number Format option.
- Further, select a Number from the appeared list.
- Finally, we will see our selected data are converted from accounting format to number format.
Read More: How to Apply Accounting Number Format in Excel
2. Utilize Context Menu to Convert Accounting Format to Number in Excel
This time, we will use the Context Menu to convert data from accounting format to number format. Let’s walk through the procedures.
- Firstly, select the range of data that are in accounting format.
- Then, right-click on the range.
- Further, select Format Cells from the context menu.
- Consecutively, a Format Cells window will appear.
- Select the Number from the Category section.
- Also, you can change the number of decimal places, by default it is 2.
- Again, you can change the way the negative numbers should appear from the Negative numbers section.
- Finally, press OK and you will see the format of the data from the selected range C4:C10 changed to Number Format.
Read More: How to Make Negative Accounting Numbers Red in Excel
3. Apply a Keyboard Shortcut to Convert Accounting Format to Number Format
There’s a keyboard shortcut for converting data from accounting format to number format. We will show the procedures to do that through the following steps.
- Firstly, select the range of data that are in Accounting format.
- Here, we selected the range C4:C10.
- Consecutively, press the keyboard shortcut Ctrl + Shift + ! (press and hold Ctrl and Shift keys then, press “!” key).
- Finally, we will see the format of the data from the selected range C4:C10 changed to Number Format.
Read More: How to Apply the Accounting Number Format to the Selected Cells in Excel
4. Utilize Custom Format to Transform Accounting Format to Number Format
This time, we will use the Custom format option to change the format of data from Accounting format to Number format. Let’s walk through the procedures.
- Primarily, select the range of data with accounting format. We selected the cell range C4:C10.
- Afterward, go to the Home tab and click on the small expansion icon beside the Number Format box.
- Then, select More Number Formats… from the appeared list.
- Instantly, a Format Cells window will appear, and select Custom from the Category section.
- Also, in the Type section select (#,##0.00) format.
- Further, press OK.
- Finally, you will see the data format from the selected range C4:C10 is changed to Number Format.
Read More: How to Simultaneously Apply Accounting Number Format in Excel
5. Insert Quick Access Toolbar to Change Accounting Format to Number
We can insert the Quick Access Toolbar for the easy accessibility of the Number Format option. Then, we can change the number format from the Quick Access Toolbar.
Follow the stepwise procedures given below.
- Primarily, go to the Home tab and right-click on the small expansion button beside the Number Format box.
- Then, select Add to Quick Access Toolbar from the appeared list.
- Now, select the range of data with accounting format. We selected the cell range C4:C10.
- Afterward, select the small expansion icon beside the Quick Access Toolbar which is situated above the Excel ribbon.
- Later on, select Number from the appeared list.
- Finally, you will see the format of the data from the selected range C4:C10 changed to Number Format.
Read More: [Fixed] Accounting Format in Excel Not Working
Download Practice Workbook
Conclusion
Changing the format of cells becomes essential sometimes. In this article, we discussed five quick methods to change the format of data from accounting format to number format. Hopefully, it will be helpful to you. If you have any queries or suggestions, let us know in the comment section.
