Accounting Format in Excel

We have seen previously in brief about how we can “Format Cell Values in Excel”. In that blog post we have learned about converting cell values in various formats but in a brief way but now ee will focus on “Accounting Format in Excel” in this blog post.

In our previous blog post we have seen 03 methods to go to additional options of formatting cell values. If you missed to read those methods, please click here before going for this blog post.

We can use any of these 03 methods to get the “Format Cells” dialog box and select “Accounting” Category as shown in below image. With this we can see all the additional options under Accounting Formats in excel.

The additional options which we can see under “Accounting Format” are shown in below image:

Sample: This option is common in all the formats which we can see under Category in above image which we can use to see how the selected numbers will look in accounting format.

Decimal Places: With this we can increase or decrease the decimal places of selected numbers in our data in Accounting Format.

Symbol: This option will add desired currency symbol to selected numbers.

Decimal Places: 

With this we can increase or decrease the decimal places of selected numbers in our data in Accounting Format.

1. We have created a dummy data of profit/loss earned by a firm in each month which is shown in below below image.

2. Select the numbers which we wish to convert into “Accounting Format” and click on the “Accounting” option under category. This will help us to see the additional options available under “Accounting Format”.

3. We can increase or decrease the decimal places of selected numbers in Accounting Format by clicking on the buttons in the highlighted area in below image.

4. Once we click on “OK” button, we will see that our selected numbers will get converted into accounting format with 02 decimal places.

Symbol: 

This option will add desired accounting symbol in front of the selected numbers.

1. We have created a dummy data of profit/loss earned by a firm in each month which is shown in below below image.

2. Select the numbers which we wish to convert into “Accounting Format” and click on the “Accounting” option under category. This will help us to see the additional options available under “Accounting Format”.

3. We can add desired Accounting symbol by selecting any of the symbols from the highlighted area as shown in below image. We can see all the available accounting symbols by clicking on drop down button. Here in this example we have selected currency symbol as “$ English (Canada)”.

4. Once we click on “OK” button we can see that the selected accounting symbol is now added in front of the selected numbers.

I hope you can now use "Accounting Format" in excel wisely while working in ou your data.