Excel Accounting Number Format: Show Negative Numbers in Red

How-to basics · Updated November 19, 2026

Yes. To show negative values in red while keeping an accounting-style currency display in Excel for Microsoft 365 on Windows, apply a custom number format such as "$"#,##0.00;[Red]("$"#,##0.00);"$"0.00. It displays negative amounts in red parentheses; the color changes how the value looks, not the value stored in the cell.

What the Accounting format does

Excel’s Accounting number format is designed to make financial columns easier to scan. It aligns currency symbols and decimal places within a column, typically places negative amounts in parentheses, and displays zero values according to the chosen format. It is useful in budgets, ledgers, and financial summaries where consistent presentation matters.

The Accounting button on the Home tab applies a preset, and its exact appearance can depend on the currency symbol, regional settings, and Excel version. A preset may not give you a red-negative option in the ribbon. A custom number format is a dependable way to request red negative values while retaining a currency symbol and parentheses. It may not reproduce every spacing detail of Excel’s built-in Accounting preset, but it provides the key visual cues.

Apply a custom format on Windows

First select the cells containing the amounts. The following steps apply a custom format to those cells without changing their underlying values:

  1. Press Ctrl+1 to open Format Cells. You can also use the dialog box launcher in the Home tab’s Number group.
  2. On the Number tab, select Custom in the Category list.
  3. In the Type box, enter "$"#,##0.00;[Red]("$"#,##0.00);"$"0.00.
  4. Select OK and check both a positive and a negative amount in the selected range.

For example, with this format, a cell whose value is -1250.5 displays as ($1,250.50), while 1250.5 displays as $1,250.50 and zero displays as $0.00. The thousands separator and decimal mark shown in your workbook can vary with regional settings.

On Excel for Mac, Command+1 generally opens Format Cells; the tab and Custom category serve the same purpose. Excel for the web has a different, more limited formatting interface. If it does not let you enter the custom code, open the workbook in the desktop app to create the format.

How the custom format works

Excel number formats can contain up to four sections separated by semicolons: positive numbers, negative numbers, zeros, and text, in that order. The example has three sections, so its first part controls positive values, its second controls negatives, and its third controls zero. The negative section begins with [Red], which tells Excel to display that section in red. Parentheses are literal display characters around the amount.

  • "$" displays a dollar sign as a literal symbol. Replace it with the currency symbol you need, such as "€" or "£".
  • #,##0.00 displays a thousands separator and two decimal places. The zeros after the decimal point require two places to appear, including trailing zeros.
  • [Red] applies red font to values using that section. Excel also recognizes other named colors in custom formats, but the available appearance depends on the application and display settings.
  • The final section, "$"0.00, gives zero a currency symbol and two decimal places. You can change or omit that section if you prefer a dash for zero.

In number formats, 0 is a required digit placeholder, while # shows a digit only when needed. The comma supplies digit grouping in this example. Excel may interpret or display separators according to your regional settings, so a workbook created under another locale might show a different separator convention.

Choose the display that suits your report

Red parentheses are a common accounting convention for negative amounts, but they are not the only reasonable choice. A report should use a pattern consistently so readers do not have to guess what the color or punctuation means. Consider how the file will be printed, shared, and read by people who may not distinguish colors easily.

  • Red with parentheses: Use the example format when you want negative amounts to stand out and prefer the familiar accounting notation.
  • Red with a minus sign: Use a negative section such as [Red]-"$"#,##0.00 if you want a visible minus sign instead of parentheses. The positive and zero sections can follow after semicolons if you need to define them too.
  • Parentheses without color: Use a format with parentheses but no [Red] when the sheet must work in grayscale or color is not part of the reporting convention.
  • Different decimal precision: Change the number of zeros after the decimal point, for example from 0.00 to 0 for whole-dollar display. Displaying fewer decimal places does not round the stored value.

Think about whether the workbook needs to show cents, how zero should appear, and whether the chosen currency symbol is unambiguous. For a multi-currency report, a single symbol such as $ may not identify the currency by itself; a currency code in a heading or a separate currency column may be clearer.

Accounting format versus Currency format

Accounting and Currency are both number formats, but they emphasize different layouts. Accounting is intended to align symbols and decimal points down a column. Currency places the symbol close to each amount, which can be more compact for a short list or a single value. Neither format converts a number into a different kind of data; both affect its display.

If the main requirement is red negative values rather than column alignment, the Currency category may be quicker if its Negative numbers choices include the red style you want. In Format Cells, select the Currency category and inspect the negative-number samples. The choices can vary with locale and version. If the specific combination of symbol, parentheses, decimals, and color is not offered, use a custom format instead. You can also apply Accounting first, then use a custom number format when the preset does not meet the report’s needs.

Number formatting does not change the amount

A common misconception is that a red number has been turned into a negative value, or that parentheses change how Excel calculates it. Neither is true. If a cell contains -1250.5, Excel continues to store and calculate with -1250.5 whether it appears in red parentheses, with a minus sign, or with no currency symbol at all. Formatting is presentation, not a calculation or accounting entry.

To verify a value, select the cell and check the formula bar. You can also use the value in arithmetic or a sum without removing its format. Conversely, applying a red format to a positive value does not make it negative. If a total is wrong, investigate the values and formulas rather than assuming that changing the number format will fix the calculation.

Custom formats can also hide detail without deleting it. For example, showing whole dollars can make 12.49 appear as 12, although the stored value remains 12.49. If exact amounts matter, display enough decimal places for the task and check the underlying value before using the sheet for reporting.

Common problems and fixes

  • Negatives remain black: Confirm the cells use the custom format and that the value is actually negative. A value stored as text will not be handled like a numeric negative amount. Re-enter or convert text values to numbers as appropriate, then reapply the format.
  • The code appears in the cell: Check that you entered it in Format Cells > Number > Custom, in the Type box, rather than typing it into the worksheet cell. Then confirm the cell is not being treated as text.
  • There is no currency symbol or the wrong one appears: Edit the quoted symbol in each relevant section of the custom format. Check the column heading too, especially if the report includes more than one currency.
  • The display has unexpected decimals or separators: Review the placeholders and regional settings. Required zeros display decimal places; optional number placeholders do not. Locale settings can affect how comma and decimal separators appear.
  • Some values are red even though they are positive: Another setting, such as font color applied directly or a conditional formatting rule, may be affecting the cells. Inspect the font color and use Home > Conditional Formatting > Manage Rules to review applicable rules.

To remove a custom format, select the cells and choose a different number format from the Home tab, or open Format Cells and select an appropriate category. Clearing formats also removes other formatting such as borders and fills, so changing the number format is usually the more targeted fix.

When conditional formatting is a better alternative

A custom number format is the right tool when the rule is simply “show every negative number in red.” If the color should depend on a more specific condition, such as an amount below -500 or a date falling in a particular period, use conditional formatting. It can change font color based on a rule while leaving the number format responsible for currency symbols, decimals, and parentheses.

Select the relevant range, then choose Home > Conditional Formatting > Highlight Cells Rules and select a rule that fits the condition. For a more tailored condition, use Home > Conditional Formatting > New Rule. Set the format to red font and check that the rule applies to the intended cells. Conditional formatting is useful for thresholds, but it adds a rule to maintain; for all negative values, the simpler custom format is often easier to understand.

Frequently Asked Questions

Can Excel’s Accounting format show negative numbers in red?
It can be done with a custom number format that includes [Red] in its negative section. The Accounting preset may not expose the exact red style you want, so use Format Cells > Number > Custom when needed.

What custom format makes negative currency values red?
For dollar amounts with two decimal places, use "$"#,##0.00;[Red]("$"#,##0.00);"$"0.00. The first section controls positive values, the second negative values, and the third zeros.

Will red formatting change a negative value into a positive one?
No. Number formatting changes only the display. A negative value remains negative for calculations, and changing its color does not alter its stored value.

Can I show negative numbers in red without parentheses?
Yes. Put a minus sign in the negative section, for example [Red]-"$"#,##0.00. You can add positive and zero sections after semicolons to control those displays as well.

Why is a negative value not turning red?
Check that the cell contains a numeric value below zero and that the custom format is applied to it. Also check for direct font formatting or conditional formatting that may override or obscure the intended appearance.

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.