Accounting vs Currency Format in Excel

Accounting vs currency format is a question of layout, not value. Both formats add a currency symbol, a thousands separator and two decimal places, and neither changes the number in the cell. The Currency format puts the symbol right next to the number and lets you choose how negatives look. The Accounting format pins the symbol to the left edge of the cell so the symbols line up, puts negatives in parentheses and shows zero as a dash. This guide shows both on the same numbers so you can pick the right one for a report, an invoice or a job test.

Accounting vs Currency format at a glance#

The short version: Accounting is built for tidy columns of money, and Currency is built for flexibility.

The examples use US dollars. In other regions Excel uses your local symbol and separators, but the differences between the two formats are the same.

What the Currency format does#

The Currency format shows a number as money with the symbol touching the first digit, such as $1,200.00. It is the format most people mean when they say "format as money".

To apply it, select the cells and press Ctrl+Shift+$ on Windows or ⌃⇧$ (Control+Shift+$) on a Mac. On Windows, this shortcut gives two decimals and negatives in parentheses. For more control, press Ctrl+1 (Mac: ⌘1) to open Format Cells, choose Currency, and set:

• Decimal places: 0 for whole dollars, 2 for cents.
• Symbol: $, €, £ and many others.
• Negative numbers: a minus sign, red text, parentheses, or red with parentheses.

That negative-number choice is the main reason to pick Currency. If your team wants losses in red, Currency can do it from the list.

What the Accounting format does#

The Accounting format is designed for financial statements. It pushes the currency symbol to the left edge of the cell and the number to the right, so every symbol and every decimal point in a column lines up.

To apply it, select the cells and click the $ button in the Number group of the Home tab. Its tooltip says Accounting Number Format. The small arrow next to it offers other symbols, such as £ and €.

Three details set it apart:

1. Negatives always use parentheses. You can't pick a minus sign or red from the list.
2. Zero shows as a dash. This keeps a report readable when many cells are empty or zero.
3. A small space on the right. Positive numbers leave room for the closing parenthesis of negatives, so the decimals stay in line with the negatives.

The Comma Style button next to the $ button applies the same Accounting layout without a currency symbol. Finance teams often use it for every row except the first and the total.

The same numbers in both formats#

Here are the same amounts formatted both ways. The values in column B are identical in each case:

In a real cell, the Accounting $ sits at the far left and the gap grows with the column width. A Markdown table can't show that, so imagine the $ signs lined up in a straight column on the left.

Add a total with =SUM(B2:B6). It returns 1,454.49 in both formats, because formatting never changes what SUM sees. A cell formatted as $1,200 that actually holds 1199.6 still adds 1199.6. If you need the rounded value, use ROUND, not formatting.

Switching a column from one format to the other#

Changing between the two formats is safe, because neither one touches the values underneath. To switch:

1. Select the cells, or click the column letter to select the whole column.
2. Press Ctrl+1 (Mac: ⌘1) to open Format Cells.
3. On the Number tab, pick Accounting or Currency from the list.
4. Set the decimal places and symbol, and for Currency, the negative-number style. Click OK.

Excel keeps your decimal places and symbol when it can, so the switch usually takes a few seconds. If some cells don't change, they probably hold text that looks like a number. Number formats only affect real numbers, so convert the text first.

When to use the Accounting format#

Choose Accounting when people will read a column of money, especially in a finance context:

• Financial statements and budgets. Lined-up symbols and decimals make long columns easy to scan.
• Reports with many zeros. Dashes make the real numbers stand out.
• Anywhere parentheses are the house style for negatives, which is common in accounting.
• Finance job tests, where a tidy, professional-looking report is part of the task.

Format the first row and the total row with the $ symbol and the rows between with Comma Style for a classic report layout.

When to use the Currency format#

Choose Currency when the number is read on its own, or when you need control over negatives:

• Prices and invoices, where $49.99 reads naturally and a gap after the $ would look odd.
• Dashboards and summary cells, such as a single "Total revenue" figure.
• Negatives in red or with a minus sign, which Accounting can't do from the list.
• Zero should look like a number, for example a price list where $0.00 means "included".

Common mistakes with money formats#

Most problems come from forgetting that a format is only a display layer:

• Expecting formatting to round. $1,200.00 might hold 1199.996. Use ROUND when the value itself must change.
• Seeing #### after formatting. Accounting and Currency add characters, so the number may no longer fit. Widen the column. The guide to #### symbols in a cell covers other causes.
• Mixing formats in one column. Some cells in Accounting and some in Currency makes the decimals jump around. Copy one cell's format to the rest with the Format Painter.
• Turning numbers into text. =TEXT(B2,"$#,##0.00") gives text that looks like money, but SUM ignores it. Use TEXT only for labels, such as ="Total: "&TEXT(B7,"$#,##0.00").
• Hunting for a stray format. If a cell keeps showing a dash or a symbol you don't want, clear the formatting and start again.

If neither built-in format is quite right, you can write your own. Accounting is itself a custom code with four sections: positive, negative, zero and text. The guide to custom number formats shows how to add red negatives or change the dash.

Our recommendation#

Use Accounting for columns of money in reports, budgets and anything a finance reader will scan. It lines up neatly and handles zeros and negatives in the standard way. Use Currency for single values, prices, invoices and dashboards, and whenever you want negatives in red or with a minus sign. In a job test, follow the wording of the task. If it says "currency format", press Ctrl+Shift+$. If it says "accounting format", use the $ button. The broader guide to formatting numbers as currency and percent covers the other shortcuts you'll need alongside these.

Practise it#

Formatting shortcuts only stick when your fingers know them. Practise the formatting shortcuts in a live spreadsheet: you apply bold, currency and percent from the keyboard and each step is checked instantly. Then practise more formatting, including Comma Style and resetting a cell to General. Or try the TEXT exercise on this page first.