How to use accounting formatting in Excel

Abstract

In this lesson we’ll take a look at the Accounting format.

Like the Currency format, the Accounting number format is designed for numbers with currency symbols.

Let’s take a look.

Let’s start off by copying a set of numbers in General format across our table.

Unlike Currency, there are no options for negative numbers.

The Accounting format places parentheses around all negative numbers by default.

Let’s set decimal places to zero.

Like Number and Currency formats, we can also adjust decimal places up and down on the ribbon.

Remember, using these buttons will automatically apply the Accounting number format, if it’s not already applied.