Taryn N
If you are looking for how to apply accounting number format, then you are in the right place. In this article we’ll try to discuss how to apply accounting number format in Excel.
Download Practice Workbook
What Is Accounting Number Format?
The Accounting Number Format is similar to the Currency format and can be applied to numbers where needed. The difference between the Accounting format and the Currency format is that the Accounting format puts the dollar sign for example, at the far left end of the cell, and displays zero as a dash. So, let’s look at a simple example in order to see how to apply the Accounting Number Format in Excel.
4 Ways to Apply Accounting Number Format in Excel
Excel offers various ways to apply accounting number format. To discuss this we have made a dataset named Dataset of Fixed Asset which includes column headers as Asset Type and Amount. The dataset is like this.
1. Using Number Ribbon Group
In the beginning method, we can use the Number ribbon group to apply accounting format.
We need to change the format type of the values in the Amount Column.
Steps:
- Firstly, select the cells which we want to change. In this case, it is C5:C10.
- Secondly, go to Home > click the drop-down dollar sign > choose $ English (United States) or you can select any option from here.
Consequently, we’ll see that all the digits are changed to accounting format.
Read More: How to Format Number with VBA in Excel (3 Methods)
2. Utilizing Drop-Down Menu
Using the drop-down menu is another option to apply accounting format.
- Firstly, select the range.
- Secondly, go to Home > click the drop-down option shown in the figure > choose Accounting.
- Eventually, the accounting format of the values will be like this.
Read More: How to Add Currency Symbol in Excel (6 Ways)
3. Using Format Cells
We can also directly use the Format Cells option. This method is also very easy to use.
Steps:
- Firstly, select the range.
- Secondly, right-click on the range > choose Format Cells.
- Eventually, a Format Cells window will appear.
- Thirdly, go to Number > select Accounting > set 2 in the Decimal Place box > select $ as Symbol.
- Fourthly, click OK.
Note: Also, you can press CTRL + 1 to open the Format Cells dialog box.
Consequently, our desired accounting format will be like this.
Read More: Excel 2 Decimal Places without Rounding (4 Efficient Ways)
4. Keyboard Shortcut
Excel has a wonderful keyboard shortcut to apply accounting format.
Suppose, we need to apply an accounting format in the cells shown below.
- Firstly, we have to select the range.
- Secondly, we just need to press ALT + H + A + N + ENTER.
As a result, we will find our accounting format in the selected range.
Read More: How to Custom Number Format in Excel with Multiple Conditions
Similar Readings
- How to Use Number Format Code in Excel (13 Ways)
- Use Phone Number Format in Excel (8 Examples)
- How to Round Numbers to the Nearest Multiple of 5 in Excel
- Convert Number to Percentage in Excel (3 Quick Ways)
- How to Change International Number Format in Excel (4 Examples)
Apply Accounting Number Format to the Selected Cells
Sometimes, we need to apply an accounting format to some selected cells. This is also easy to use. We just need to select multiple desired distinct cells at a time. Suppose we need to apply accounting format in the C6, C8 and C9 cells.
Steps:
- Firstly, select the C6, C8 and C9 cells at a time while holding the CTRL key.
- Secondly, right-click on any of the selected cells.
- Thirdly, choose Format Cells.
- Fourthly, go to Number > select Accounting > set 2 in the Decimal Place box > select $ as Symbol.
- Fifthly, click OK.
Eventually, we’ll see that the accounting format is added only to the selected cells.
Read More: How to Round up Decimals in Excel (5 Simple Ways)
Apply Accounting Number Format with 0 Digits After the Decimal
If we want to apply an Accounting Number Format with 0 digits after the decimal, Excel offers us a couple of ways to do that.
Here, we have already applied accounting number format to the cells C5:C10 following any of the methods described above. We just need to delete the digits after the decimal.
One thing we can do is we just need to change the Decimal Place box to 0 of the Format Cells box.
And after clicking OK, we’ll see that there are 0 digits after the decimal place.
Alternatively, we can do it in another way that we just need to select the range and then click the icon marked in the Number box. The number of clicks should be equal to the number of digits after decimal.
Read More: Excel Round to 2 Decimal Places (with Calculator)
Conclusion
We can apply the accounting number format very easily if we study this article properly. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.
Related Articles
- How to Display Long Numbers in Excel (4 Easy Ways)
- Custom Cell Format Number with Text in Excel (4 Ways)
- How to Format a Number in Thousands K and Millions M in Excel (4 Ways)
- Custom Number Format: Millions with One Decimal in Excel (6 Ways)
- How to Apply Number Format in Millions with Comma in Excel (5 Ways)
Excellent tutorial. Thanks for sharing the valuable content.