Excel Accounting Format: Make Negative Values Display in Red

To show negative amounts in red in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, open the Number tab, choose Custom, and enter $#,##0.00;[Red]($#,##0.00);$0.00;@. This displays positive values with a dollar sign, negative values in red parentheses, zero as $0.00, and text unchanged; it changes appearance, not the underlying values.

What Accounting Format Means in Excel

Excel’s Accounting number format is designed for financial statements and other tables of money amounts. It lines up currency symbols and decimal points in a column, displays negative figures in parentheses by default, and commonly shows zero as a dash. That visual consistency can make a balance sheet or expense report easier to scan than a column of ordinary currency-formatted values.

The standard Accounting format does not necessarily show negative numbers in red. The custom format above adds that color to the negative-number section while keeping a familiar financial appearance. Its four parts, separated by semicolons, control positive numbers, negative numbers, zeros, and text, in that order. The dollar sign is included as a literal symbol. To use another currency, replace it with the symbol you need, or use the Accounting category to select a currency symbol available in your Excel setup.

One distinction matters: the example is accounting-style, but it does not reproduce every alignment feature of Excel’s built-in Accounting format. Custom formats can control display details, while the built-in format is useful when lining up symbols across a column is a priority. Choose based on whether color-coding negatives or strict accounting alignment matters more to your report.

Apply a Custom Format for Red Negatives

In Windows Excel for Microsoft 365, apply the custom format to the cells that contain amounts. The steps below affect only the selected cells; they do not change the values or formulas.

Select the amount cells. To select a continuous range, click the first cell, hold Shift, and click the last. You can also drag across the range.
Press Ctrl+1 to open Format Cells. Alternatively, use Home > Number group dialog launcher, the small arrow at the lower-right of the Number group.
On the Number tab, select Custom in the Category list.
Enter $#,##0.00;[Red]($#,##0.00);$0.00;@ in the Type box and select OK.

On a Mac, select the cells and press Command+1 to open Format Cells, then use the Number tab and Custom category in the same way. The exact dialog layout can differ slightly between Excel for Windows and Excel for Mac, but the custom number-format syntax is generally the same. In Excel for the web, number-format options are available from the Home tab, but its interface may not expose every custom-format feature available in the desktop app; if you cannot enter the code there, open the workbook in desktop Excel.

For example, if a cell contains 1250, it displays as $1,250.00. If it contains -1250, it displays as red ($1,250.00). A stored value of 0 displays as $0.00. If the amount is 1250.5, Excel displays $1,250.50. The displayed color depends on the cell’s font color setting and the theme or color handling in the application, so confirm that red is distinguishable in your workbook.

Understand the Format Code

Excel custom number formats can contain up to four sections, divided by semicolons. In the example, each section has a specific role:

$#,##0.00 formats positive numbers with a dollar sign, a thousands separator, and two decimal places.
[Red]($#,##0.00) formats negative numbers in red and puts the amount in parentheses.
$0.00 sets the appearance of zero values.
@ displays text entered in a cell as text.

The comma in the number pattern is a thousands separator according to the workbook’s regional settings, while the period marks the decimal position in the format code shown. Excel may display separators differently under regional settings. The red instruction applies only to the negative section, so positive amounts and zeros do not turn red just because they share the same custom format.

Two decimal places are a choice, not a requirement. For whole-dollar reporting, use $#,##0;[Red]($#,##0);$0;@. For three decimal places, add another zero after the decimal point in each numeric section. The number format controls what is shown, not how much precision is stored: a value such as 4.567 can remain in the cell even when a two-decimal format displays it as $4.57.

Choose Between Red, Parentheses, and a Minus Sign

Red text draws attention to a negative balance, while parentheses are a familiar convention in many financial reports. They can be used together, as in the example, but neither presentation is suitable for every audience. A report designed for printing in grayscale may lose the color distinction, so parentheses or a minus sign should still make the negative value recognizable.

If you prefer a minus sign rather than parentheses, change only the negative section. For example, $#,##0.00;[Red]-$#,##0.00;$0.00;@ displays a negative 1250 as red -$1,250.00. If you want negatives in red without either parentheses or a currency symbol, a simpler code is #,##0.00;[Red]-#,##0.00;0.00;@. These patterns are examples; match the decimal places, symbol, and conventions used in the rest of the workbook.

When symbol alignment is essential, use Excel’s built-in Accounting format and review the negative-number options offered by the dialog in your version. The Currency category may offer different negative styles from Accounting. If the particular built-in choice you need is not available, a custom format gives direct control over the sign, parentheses, decimals, and color, but may not align currency symbols in precisely the same way.

Formatting Is Not the Same as Changing a Value

A number format does not turn a positive number into a negative one, change a formula, or create a new accounting entry. It is a display instruction. If a formula returns -1250, the custom format makes that negative result red; if it returns 1250, the result remains positive and is displayed in the positive style. The formula bar continues to show the underlying value or formula.

This is different from Conditional Formatting. A custom number format is useful when every negative value in a selected range should follow the same display convention. Conditional Formatting is more appropriate when color depends on additional criteria, such as a balance being below a target or an amount belonging to a particular category. Conditional Formatting changes visual styling according to rules; it does not replace the number format’s control over decimal places, symbols, or parentheses.

Also distinguish a negative amount from a number stored as text. Formatting cannot make text behave like a number in calculations, and a text entry such as the characters “-1250” may not respond as expected to a numeric format. If a cell does not change, check whether its value is a real number or whether it contains an apostrophe or other text-related import issue.

Common Problems and Fixes

Negatives stay black: Reopen Format Cells and confirm that [Red] is in the second section, immediately before the negative pattern. Check that the selected range includes the cells you are inspecting.
All values show the wrong currency: The example explicitly uses a dollar sign. Replace it with the appropriate currency symbol, or choose a symbol using the built-in Accounting category.
Decimals or separators look different: Confirm the number of zeros after the decimal point and consider regional settings. A format can display a rounded figure without rounding the stored value.
The code appears in the cell: Make sure you entered it in Format Cells > Number > Custom, not directly into the worksheet. Also check that the cell is not being treated as text.
Color disappears in a printout: Do not rely on red alone to communicate a negative value. Keep parentheses or a minus sign, and check print preview or a grayscale copy.
The existing format was replaced: Applying a new custom format replaces the selected cells’ previous number-format choice. You can reopen Format Cells and choose another category, or use Undo immediately if the change was unintended.

For a large workbook, apply the format to the intended data range rather than an entire worksheet unless that is genuinely needed. A consistent style is useful, but formatting blank cells far beyond the report can make later editing less clear. If only one column should have red negatives, select that column’s data cells and leave headings and notes alone.

Where Red Negative Formatting Is Useful

Red negatives are commonly helpful in expense summaries, account balances, cash-flow reports, budget comparisons, and management dashboards. In an expense report, a negative adjustment can stand out from ordinary positive charges. In a balance column, red parentheses can make an amount below zero easier to find without changing the order or structure of the worksheet.

Context determines whether red means “bad.” In a profit-and-loss report, a negative profit may need attention. In a cash-flow statement, a negative movement may be expected and meaningful rather than erroneous. Do not use color as a substitute for labels or explanations: a reader should be able to tell what the amount measures and what a negative sign means even when the workbook is printed without color.

It is also helpful to keep zero values distinct from blanks. The example displays a real zero as $0.00, while an empty cell remains empty. In a report where dashes are preferred for zero, change the third section rather than hiding the value. This makes it possible to distinguish “no amount recorded” from “the calculated amount is zero.”

Frequently Asked Questions

Can Excel Accounting format show negative numbers in red?
Yes, by applying a custom number format with a red negative section, such as $#,##0.00;[Red]($#,##0.00);$0.00;@. This keeps negative values in parentheses and colors them red. The built-in Accounting format may not offer that exact combination in its dialog.

Will this change the number or formula?
No. Number formatting changes how Excel displays the value. Calculations continue to use the underlying number, including any decimal places hidden by the display format.

How do I show negative numbers in red without parentheses?
Use a negative section with a minus sign, such as $#,##0.00;[Red]-$#,##0.00;$0.00;@. Apply it through Format Cells > Number > Custom.

Why is my negative value still black?
Check that the cell contains a numeric negative value, that the custom format is applied to that cell, and that [Red] is in the second section of the format. A text value that looks negative will not necessarily respond like a number.

Can I make zero display as a dash?
Yes. Replace the third section in the format code with a quoted dash, for example $#,##0.00;[Red]($#,##0.00);-;@. Test the appearance in your workbook and keep in mind that a displayed dash still represents a numeric zero.

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.