Excel Accounting Format: How It Works and When to Use It Properly

How-to basics · Updated November 18, 2026

Excel’s Accounting number format displays monetary values with currency symbols and decimal points aligned in a column; apply it by selecting the cells and choosing Home > Number > Accounting Number Format. It changes how numbers look, not the underlying values, so it is a presentation format rather than an accounting system or a way to make a workbook financially compliant.

What Excel’s Accounting format does

Accounting is one of Excel’s built-in number formats. It is designed for financial tables in which consistent alignment makes amounts easier to scan. Compared with a plain number format, it gives currency symbols and decimal places a more structured appearance: symbols sit at the left edge of the cell, while amounts and decimal points line up down the column. Depending on the selected option and regional settings, zero values are commonly displayed as a dash and negative amounts may appear in parentheses.

The format does not add a currency symbol to the stored value, convert one currency into another, or change the arithmetic. A cell containing the number 1250 remains the number 1250 after formatting; Excel can still use it in sums, comparisons, and other calculations. The symbol is a display choice. If one cell shows a dollar sign and another a pound sign, that does not by itself mean Excel has converted either amount.

Accounting is useful for totals, budgets, expense reports, invoices, and financial statements where a column of monetary figures needs a uniform layout. It is less useful for ordinary counts, dates, or values where a currency symbol would be misleading.

How to apply Accounting format in Excel

In Excel for Microsoft 365 on Windows, select the cells, then use the Accounting Number Format control on the Home tab. The button may show a currency symbol; its dropdown lets you choose a symbol or more accounting options. To adjust decimal places or choose a specific locale, open the Format Cells dialog instead.

  1. Select the cells or range you want to format. To format a whole column, click its letter at the top of the worksheet.
  2. On the ribbon, choose Home > Number > Accounting Number Format. Use the dropdown arrow beside the control to choose a currency symbol if necessary.
  3. For detailed settings, press Ctrl+1 to open Format Cells, select the Number tab, choose Accounting, set decimal places and the symbol, and select OK.

In the Format Cells dialog, the Accounting category typically offers a decimal-place setting and a symbol list. Select the appropriate currency symbol for the values you are presenting, rather than assuming Excel will infer the currency from the number. In Excel for Mac, use the Home tab’s number-format controls or open Format Cells; Control+1 is the corresponding shortcut in many Mac keyboard layouts. Ribbon labels and shortcut behavior can vary with platform and configuration. Excel for the web has number-format controls on its Home tab, though the desktop dialog may provide more options.

To remove the appearance without changing the values, select the cells and choose Home > Number format dropdown > General. You can also use Clear Formats, but that removes other formatting too, such as font, fill, and borders. General is the more focused choice when you only want to reset the number format.

How symbols, decimals, zeros, and negatives appear

Accounting format gives a column a shared visual structure. For example, if a column contains 45, 1250.5, and 0, the amounts will be displayed with the chosen currency symbol and a consistent number of decimal places. With two decimal places, the first two values display to the hundredth; a zero may display as a dash. The actual stored numbers remain 45, 1250.5, and 0.

The display of negative amounts is a common reason people choose Accounting. Parentheses can make a negative amount visually distinct without relying on a minus sign. However, the precise treatment of negative values and zeros can depend on the selected built-in option, symbol, and regional format. Preview the result in the sheet rather than assuming every installation will display it identically.

Currency symbols are also locale-sensitive. A dollar sign can represent different currencies, and a symbol alone may not identify which one is intended. For reports shared across regions, label the column or report with the currency and, where needed, use a more explicit notation such as USD or EUR in a heading. Formatting does not perform an exchange-rate calculation.

Choosing Accounting, Currency, or Number

Accounting and Currency are both intended for monetary values, but they prioritize different layouts. Accounting aligns currency symbols and decimal points across a column and commonly represents zero with a dash. Currency places the symbol closer to each value and can be a better fit for individual amounts in prose or a compact display. The exact appearance depends on the settings and locale.

Number format is appropriate when the figures are counts, quantities, or measurements rather than money. It can show thousands separators and decimal places without adding a currency symbol. For example, a column of units sold should normally be formatted as a number, while a column of sales revenue may use Accounting or Currency.

  • Choose Accounting for financial tables where aligned symbols, decimals, and clear negative values matter.
  • Choose Currency when each individual value should have a nearby currency symbol and tighter spacing is useful.
  • Choose Number for non-monetary values, or when the currency is already stated clearly in a heading.

Neither Accounting nor Currency is inherently more accurate. They are display choices. The best option is the one that makes the meaning clear and keeps the table readable for its intended audience.

Changing the currency symbol and decimal places

To change the settings for a range, open Format Cells with Ctrl+1, choose the Number tab, and select Accounting. Set the number of decimal places and select the desired symbol from the Symbol list, then confirm. The built-in format options generally let you choose a symbol and decimals without creating a custom number format.

For whole-dollar reporting, setting decimal places to zero can make a table easier to read, but it rounds only the display. For instance, an underlying value of 18.76 may appear as 19 with zero displayed decimal places; the stored value remains 18.76 and calculations continue to use it. If a report must use rounded amounts in its calculations, that is a separate decision about the data or formulas, not a consequence of formatting.

Changing the symbol also does not convert the amount. If a value of 100 is formatted with a euro sign instead of a dollar sign, Excel displays a different symbol beside the same numeric value. To report a converted amount, a conversion calculation must be performed using an appropriate exchange rate and the assumptions for the report.

Common problems and what they mean

If a cell does not show a currency symbol after applying the format, confirm that you selected Accounting rather than Number, and check the symbol choice. A narrow column can also make values display as hash marks (#####). Widen the column by dragging the boundary between its column letters or double-clicking that boundary to AutoFit. Hash marks usually indicate that the formatted value does not fit; they do not mean the value has disappeared.

If decimals or parentheses look different than expected, revisit Format Cells and inspect the selected symbol, decimal places, and category. Regional settings can affect separators and currency conventions: some locales use a comma for decimals and a period for thousands, for example. Formatting choices can therefore look different on another computer even when the underlying value is identical.

A frequent misconception is that applying Accounting makes text that looks like a number into a usable number. It does not. If a value was imported as text, changing its number format may have no visible effect and formulas may not treat it as numeric. Check whether the cell is stored as a number, and use Excel’s conversion tools or correct the import process where needed. Also remember that a displayed dash can represent a true zero under the format, not a blank cell.

Good practices for financial worksheets

Use one consistent format for comparable amounts within a table. A report where some rows show cents and others do not can suggest a difference in precision that may not exist. Apply formatting to the entire relevant range, including totals, and check how blank cells, zero values, and negative values appear. If a subtotal is meant to stand out, use appropriate font weight or borders rather than changing its number format arbitrarily.

Make the currency clear in a heading or note, especially if readers may see the workbook outside the region where it was prepared. Keep assumptions—such as whether figures are rounded or whether a column is in thousands—visible. For example, a heading such as “Expenses (USD)” communicates more than a dollar symbol alone. Formatting can support clarity, but it cannot replace labels, reconciliations, or sound bookkeeping procedures.

Before sharing a workbook, inspect it at its likely viewing size and check that columns are wide enough. Consider printing or exporting a sample page if the worksheet is intended for a report. A format that looks aligned in a wide desktop window may become cramped in a printout or on a smaller screen.

Frequently Asked Questions

Does Excel Accounting format change the value?
No. It changes the display of a number, not the stored value. Excel continues to calculate using the underlying number, including decimal places that may not be visible.

Why does Accounting format show a dash instead of zero?
Many Accounting format options display zero as a dash to make financial tables easier to scan. The cell still contains zero. Choose another number format or adjust the display settings if you need zeros shown explicitly.

How do I show negative amounts in parentheses?
Select the range, open Format Cells with Ctrl+1, choose Number > Accounting, and inspect the available format preview. Negative-value display can depend on the selected option and regional settings.

Can I use Accounting format without a currency symbol?
Accounting’s built-in layouts are designed around a currency symbol. If you want aligned decimals without a symbol, use a suitable Number format or a carefully chosen custom format, and check the result against the workbook’s regional settings.

Does changing the symbol convert the currency?
No. Selecting a different symbol changes only what appears in the cell. Currency conversion requires a separate calculation using an exchange rate; formatting alone never changes the amount.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.