Excel Accounting Format: Show Negative Numbers in Brackets

How-to basics · Updated November 18, 2026

Yes. In Excel for Microsoft 365 on Windows, the Accounting number format commonly displays negative values in parentheses—often called brackets in everyday speech—while keeping the underlying number negative and unchanged. Select the cells and choose Home > Number > Accounting Number Format; for a precise custom display, use a custom number format with separate positive and negative patterns.

What Excel means by Accounting format

Excel’s Accounting format is a number format intended for financial tables. It can align currency symbols and decimal points down a column, making totals and amounts easier to scan. In many regional settings, negative amounts appear in parentheses, such as ($125.00), and zero may appear as a dash. The precise symbol and appearance depend on the chosen currency and regional settings.

People often say “brackets” to mean parentheses, but the characters are different: parentheses are ( ), while square brackets are [ ]. Accounting statements conventionally use parentheses to indicate a negative amount. Excel’s custom-format codes also use square brackets for special instructions, including colors and conditions, so putting square brackets around a number is not the same thing as selecting the Accounting format.

The format changes how a value looks, not what it is. A cell displaying ($125.00) still contains the numeric value -125. Formulas, sorting, and calculations continue to use that negative value. This distinction matters when someone copies a report into another system or checks a balance: the display is not evidence that the underlying value has been converted to text.

Apply the built-in Accounting format

For the standard accounting appearance, try the built-in format first. In Excel for Microsoft 365 on Windows:

  1. Select the cells, column, or range that contains the amounts.
  2. Go to Home and look in the Number group.
  3. Select the arrow beside Accounting Number Format, often shown with a currency symbol, and choose the currency or regional option you need.

The button applies an Accounting format; its drop-down lets you select a currency symbol or regional variant. Depending on the workbook’s locale and the selected option, negative amounts are generally shown in parentheses. Check a known negative cell after applying it rather than assuming every workbook will display the symbol and separators identically.

You can also open the Format Cells dialog with Ctrl+1 on Windows, choose the Number tab, select Accounting, and set the decimal places and symbol. In Excel for Mac, Command+1 opens Format Cells; ribbon labels and dialog details can vary slightly by release. Excel for the web offers common number-format controls, but its custom-format editing options are more limited than desktop Excel. If you need to create or carefully edit a custom pattern, open the workbook in the desktop app.

Use a custom format for a specific pattern

If the built-in style does not give you the exact result, a custom number format lets you define how positive, negative, zero, and text entries display. On desktop Excel, select the cells, press Ctrl+1 on Windows (Command+1 on Mac), choose Number > Custom, enter the pattern in the Type box, and select OK. For a US-dollar example with two decimal places, parentheses around negatives, a hyphen for zero, and unchanged text, use:

$#,##0.00;($#,##0.00);-;@

Custom formats use semicolons to separate sections in this order: positive values; negative values; zero values; text. In the example, the second section surrounds a negative amount with parentheses, while the third displays zero as a hyphen. The final @ passes text through as entered. If you want zero to display as $0.00 instead, remove the third section so Excel uses the positive pattern for zero, or specify a zero pattern that suits your report.

For example, a cell containing -1250.5 displays as ($1,250.50) with that pattern; a cell containing 0 displays as a hyphen. The stored values remain -1250.5 and 0. Replace the dollar sign with the appropriate currency symbol for your report. In some regions, Excel uses different decimal and thousands separators, and currency symbols or format conventions can be locale-dependent. Verify the preview and a sample value in your own workbook.

Accounting, Currency, and parentheses

Accounting and Currency formats both display monetary values, but they are designed for somewhat different layouts. Accounting typically places currency symbols consistently at the left side of the cell and aligns decimal points in a column. Currency usually places the symbol close to the number. Accounting may also use a dash for zero and parentheses for negative numbers, depending on the selected option and regional format; Currency offers its own negative-number display choices in the Format Cells dialog.

If your main requirement is simply to show negatives in parentheses, Currency may be sufficient and can provide a convenient negative-number choice. If you are preparing a columnar financial statement and want aligned symbols and decimal places, Accounting is often a better fit. A custom format is useful when you need a particular combination—for example, no currency symbol, a dash for zero, or parentheses with a specific decimal precision.

These formats do not make a worksheet compliant with a particular accounting standard or guarantee that a report is suitable for filing. They control presentation. If a report has prescribed formatting rules, follow those rules and check the actual values and calculations separately.

Choose decimals, symbols, and alignment

Before formatting a whole table, consider what readers need to compare. A sales report might use two decimal places for prices but none for rounded whole-dollar totals. A balance sheet may show a currency symbol in the first amount on a block and omit it on later rows to reduce visual clutter, depending on the reporting convention being followed.

  • Decimal places: Choose a consistent precision for amounts that readers are meant to compare. Formatting to zero decimals rounds the display; it does not round the stored value.
  • Currency symbol: Select the symbol that matches the currency being reported. A symbol alone can be ambiguous across currencies, so use a clear heading or label when needed.
  • Zero display: A dash can distinguish a true zero from an empty cell, but make sure readers understand the convention.
  • Column width: Accounting layouts take space to align symbols and values. Widen the column if Excel displays hash marks instead of the number.
  • Consistency: Apply one deliberate style to comparable amounts. Mixed precision or different negative styles can make a column harder to interpret.

Remember that displayed rounding is not the same as rounding the amount. If a cell contains 12.345 and the format shows two decimal places, it may display as 12.35 while retaining the more precise value for calculations. If a calculation itself must be rounded, use an appropriate formula or revise the source data; number formatting alone does not alter it.

Why negatives may not appear in parentheses

If a negative number still appears with a minus sign, first check whether the cell actually has the Accounting format. A workbook may have a custom format, a copied style, or a regional variant that displays negatives differently. Select the cell and inspect the Number Format list on the Home tab or open Format Cells with Ctrl+1. Applying the format again to the affected range can resolve a simple mismatch.

Also check whether the cell contains text rather than a number. A value imported with an apostrophe, unusual spaces, or a text marker may not respond to number formatting. If it is text, changing the format will not turn it into a numeric value; convert the data appropriately before relying on calculations. A quick clue is that numeric values usually behave as numbers in arithmetic and sorting, whereas text may sort or calculate unexpectedly.

Conditional formatting can also change the appearance of cells, and a custom number format may contain a rule that overrides the pattern you expect. If only some cells look different, inspect their formats and any conditional formatting rules. Check whether the cells are part of a table with a style or whether a pasted range brought over formatting from another workbook.

Common misconceptions and practical checks

Parentheses do not mean that Excel has stored a positive number. The minus sign may be hidden by the display pattern, but the stored value remains negative. You can confirm by selecting the cell and looking at the formula bar, or by using the value in a simple calculation. Likewise, changing a negative display to parentheses does not change a sum, reverse a sign, or repair an incorrect source amount.

Another common misunderstanding is that all parentheses are square brackets. In number-format syntax, square brackets have special meanings and can specify conditions such as [Red] or numeric thresholds. For ordinary accounting presentation, use parentheses in the negative section of the format, as in ($#,##0.00), rather than treating square brackets as interchangeable punctuation.

Before sharing a formatted report, check at least one positive value, one negative value, a zero, and any text labels in the same range. Confirm that totals still calculate as intended and that symbols and decimal places are consistent. If recipients use a different locale or spreadsheet program, the underlying numeric values are more reliable than assuming every environment will render the format identically.

Frequently Asked Questions

How do I put negative numbers in parentheses in Excel?
Select the cells and apply Home > Number > Accounting Number Format. If that does not produce the exact pattern you need, use Format Cells > Number > Custom and enter a format with a negative section such as $#,##0.00;($#,##0.00);-;@.

Does Excel Accounting format change a negative number?
No. It changes the number’s appearance, not its value. A cell displayed as ($125.00) still contains -125, so calculations continue to treat it as a negative amount.

Why does Excel show a minus sign instead of parentheses?
The selected format, currency option, locale, or a custom format may use a minus sign. Check the cell’s number format and choose Accounting or define a custom negative section. Also check for conditional formatting if only certain cells look different.

Can I show zero as a dash and negatives in parentheses?
Yes. A custom pattern such as $#,##0.00;($#,##0.00);-;@ uses the third section to display zero as a hyphen and the second to put negative values in parentheses. The displayed dash is still a numeric zero underneath.

Do parentheses mean the cell is text?
No. Parentheses are just part of the display pattern. The cell can remain numeric and participate normally in arithmetic. If a value does not calculate as a number, investigate whether the source data was imported or entered as text.

Can I use square brackets instead of parentheses?
Excel permits literal characters in custom formats, but square brackets also have special roles in format codes and are not the usual accounting convention for negative amounts. For a familiar financial display, use parentheses.

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.