How to Apply Accounting Number Format in Excel! (Easy way)

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

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

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

3) The Accounting Format is thus 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.

Further Readings

• Excel 2 Decimal Places without Rounding (4 Efficient Ways)
• Excel Round to Nearest 100 (6 Quickest Ways)
• How to Round up Decimals in Excel (4 Simple Ways)
• How to Round Off Numbers in Excel (4 Easy Ways)
• How to Round to Nearest Multiple of 5 in Excel (3 Easy Ways)
• Excel Number Stored As Text [4 Smart Ways]
• Add or Keep Leading Zeros in Excel (10 Suitable Ways)
• Excel Custom Number Format Multiple Conditions
• How to Round Numbers in Excel Without Formula (3 smart ways)
• How to Remove Leading Zeros in Excel (7 Easy Ways + VBA)