Excel Number Format: Red Negative Numbers in Brackets

How-to basics · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, choose Number > Custom, and enter #,##0.00;[Red](#,##0.00). Negative values will display in red with parentheses, while positive values remain black; the cell values themselves do not change.

How the red negative format works

An Excel number format controls how a value appears, not the value stored in the cell. The custom code above has two sections separated by a semicolon: the first controls positive numbers and zero, and the second controls negative numbers. In the second section, [Red] sets the font color and parentheses surround the displayed number. For example, a stored value of -1250.5 appears as (1,250.50) in red when the workbook uses a comma for thousands and a period for decimals.

The code’s components have distinct jobs:

  • # is a digit placeholder that does not force an extra zero to appear.
  • 0 is a digit placeholder that displays a zero when there is no digit in that position.
  • The comma separates thousands in regions that use that convention.
  • The period introduces decimal places in the example’s regional style.
  • ;[Red] begins the negative-number section and assigns its color.
  • The parentheses in that section are displayed around the negative value.

The formatting does not turn the stored number into text or make it positive. Excel can still add it, compare it, use it in formulas, and recognize it as a negative number. A formula bar will generally show the underlying value rather than the formatted appearance.

Apply the format in Excel for Windows

  1. Select the cells or range to format. You can select a whole column if new entries in that column should use the same display.
  2. Press Ctrl+1 to open the Format Cells dialog.
  3. On the Number tab, select Custom in the category list.
  4. Click the Type box, replace its contents with #,##0.00;[Red](#,##0.00), and select OK.

You can also open Format Cells from the dialog launcher in the Home > Number group. If you prefer not to write a custom code, check the built-in formats under Number in the same dialog: Excel offers negative-number display choices, including red and parenthesized styles in many regional settings. The custom route gives you more control over decimal places, zero display, and literal characters.

In Excel for Mac, select the cells and press Command+1 to open Format Cells, then use Number > Custom and enter the format. Ribbon placement and dialog appearance can vary slightly between Mac and Windows releases, but the custom format concept is the same. In Excel for the web, an existing custom format can be displayed with the workbook; use desktop Excel if you need the full custom-format editing dialog and cannot find the required controls in the web interface.

Choose decimals, separators, and a minus sign

The sample code shows two decimal places for both positive and negative values. If you want whole numbers, remove the decimal point and zero placeholders: #,##0;[Red](#,##0). A value such as -1250.5 will then be rounded for display to (1,251), but the stored value remains -1250.5. If you want one decimal place, use #,##0.0;[Red](#,##0.0). These choices affect displayed precision, not the precision of calculations.

Parentheses are a common accounting-style way to mark negative amounts, but a minus sign may be clearer in some tables. To keep the minus sign and color the number red, use #,##0.00;[Red]-#,##0.00. A negative value then appears similar to -1,250.50 in red. You can also change the grouping and decimal placeholders to suit the workbook’s conventions.

Excel’s displayed separators depend on regional settings. A workbook created in a locale that uses a period for grouping and a comma for decimals may show different separators or require a locally adapted code when editing it. If the format appears invalid or its separators are unexpected, check the workbook’s regional conventions and the characters shown in the Type box rather than assuming the US-style example will display identically everywhere.

Use square brackets instead of parentheses

People sometimes say “brackets” when they mean parentheses: (123). If you mean actual square brackets around the negative number—[123]—put those characters in the negative section as literals. For example, use #,##0.00;[Red]"["#,##0.00"]". The quotes tell Excel to display the square-bracket characters as text, while [Red] remains a formatting instruction. A negative 1,250.50 then appears as [1,250.50] in red.

This distinction matters because square brackets already have a special role in custom number formats. Excel uses them for instructions such as colors and conditions, so an unquoted bracket may be interpreted as part of the format syntax rather than as a character to print. Quoting literal characters avoids that ambiguity. If you only want the conventional accounting appearance, parentheses are simpler and easier to scan in most financial tables.

Control how zeroes and text appear

A custom number format can contain up to four sections, separated by semicolons, in this order: positive numbers; negative numbers; zero; text. The two-section format in the opening example uses the first section for positive numbers and zero, and the second for negative numbers. That is often all a reader needs.

If you want zero to appear as a dash and text to remain visible, use this four-section format: #,##0.00;[Red](#,##0.00);-;@. The third section displays a dash for zero, and @ is the text placeholder in the fourth section. For example, a positive 25 displays as 25.00, a negative 25 displays as (25.00) in red, zero displays as a dash, and a text entry such as Pending remains visible. Choose a zero style deliberately: hiding zeroes or replacing them with dashes can make a report look cleaner, but it can also obscure meaningful data.

Sections are assigned by value type and sign, not by a cell’s position in the worksheet. If you add a conditional color instruction to the negative section, Excel applies it to negative numeric values in cells with that format; it does not search the cell’s text for a minus character.

Number formatting versus conditional formatting

A custom number format is a good fit when every negative number in the selected range should look the same. It travels with the cell’s formatting and keeps the displayed value numeric. Use conditional formatting instead when the color depends on a rule more specific than “the value is negative,” such as values below a threshold, values that breach a target, or values that should be colored based on another cell.

For a simple threshold rule in Excel for Windows, select the range and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than. Enter the cutoff and choose a suitable format, or use the custom formatting option in the dialog to set the font color. Conditional formatting can take precedence visually over a number format’s font color, depending on the rules applied. If a negative value does not appear red, inspect the range’s conditional-formatting rules as well as its custom number format.

Neither method changes the underlying number. Conditional formatting is more adaptable for rule-based highlighting; a custom number format is compact and can combine color, parentheses, decimals, and zero presentation in one cell format. Choose based on what should trigger the appearance, not just on which route seems shorter.

Common problems and quick checks

  • The format colors positive values or fails to color negatives: Check the semicolon. The first section is for positives and zero; the second is for negatives. Make sure [Red] is in the negative section.
  • The negative number has no parentheses: Confirm the opening and closing parentheses are in the second section, after the color instruction and around the number placeholders.
  • The number of decimals looks wrong: Each zero after the decimal placeholder forces a displayed digit. Two zeros mean two displayed decimal places, even when the underlying value has more precision.
  • The cell shows the format code instead of applying it: Reopen Format Cells and enter the code in the Type box under Custom, not directly into the worksheet cell.
  • A value does not behave like a number: The cell may contain text that looks numeric. Number formats affect numeric values, not text entries. Check whether the value is stored as text before troubleshooting the format.
  • Red does not show on screen or in a printout: Check the font color, conditional-formatting rules, display settings, and printer output. On a monochrome printout, red may become a gray shade, so retain parentheses or a minus sign to communicate that the value is negative.

Also distinguish a displayed negative from a genuinely negative value. A custom format cannot turn a positive value into a negative one; it only controls appearance. Conversely, a displayed value rounded to zero may still be a small negative number underneath. If the sign matters for calculations, inspect the underlying value in the formula bar or increase the displayed decimal places.

Frequently Asked Questions

What is the simplest Excel format for red negative numbers in parentheses?
Use #,##0.00;[Red](#,##0.00) in the Custom Type box. It shows two decimals, thousands grouping, and red parentheses for negatives.

Can I make negative numbers red without parentheses?
Yes. Use a negative section with a minus sign, such as #,##0.00;[Red]-#,##0.00. This displays a red minus sign before the negative number.

Will this format change the value or affect formulas?
No. It changes the display only. The value remains negative, and Excel continues to use that numeric value in calculations, sorting, and comparisons.

Can I show zero as a dash while keeping negatives red?
Yes. Use #,##0.00;[Red](#,##0.00);-;@. Its third section displays zero as a dash, while its second section formats negatives in red parentheses.

Why do my square brackets not appear?
Square brackets have special meaning in Excel format codes. Put literal square brackets in quotation marks in the negative section, as in [Red]"["#,##0.00"]", so Excel displays them instead of interpreting them as formatting syntax.

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.