How to Apply Accounting Number Format in Excel!

The Accounting 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 Accounting number format in Excel.

How to Apply Accounting Number Format in Excel

An accountant working at a hypothetical accountancy firm is compiling a spreadsheet noting the value of fixed assets, for the current financial year as shown below.

How to apply accounting number format in excel - Image 1

1) In order to apply Accounting format, select the range and right-click and choose Format Cells.

Accounting number format in Excel - Image 2

2) In the Format Cells Dialog box, with the Number Tab selected, choose Accounting and accept the options shown below and click Ok.

Format Cells dialog box

3) The Accounting Format is thus applied.

Accounting number format is applied

And there you have it.

Download Excel File

ApplyingAccountingFormat

Conclusion

Applying the Accounting format is simple and straightforward in Excel. One can use the Accounting format when compiling financial statements, balance sheets and for other Accountancy related purposes.

Please feel free to comment and tell us about the formats you use in your spreadsheets.

Useful Links

What is a fixed asset?

The Difference between Currency and Accounting Format

Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience. She has a background in biochemistry, Geographical Information Systems (GIS) and biofuels. She enjoys showcasing the functionality of Excel in various disciplines.

In her spare time when she’s not exploring Excel or Access, she is into graphic design, amateur photography and caring for her two pets, Pretzel and Snoopy.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve the Math * Time limit is exhausted. Please reload CAPTCHA.