Excel Custom Number Format for Negative Numbers in Brackets

How-to basics · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, use a custom number format with a semicolon separating positive and negative formats: enter 0;(0) to show negative values in parentheses, or 0;\[0\] to show them in square brackets. The brackets in the second code are escaped so Excel displays them as characters rather than treating them as formatting instructions.

What “brackets” means in a number format

People often use “brackets” to mean either round parentheses, such as (125), or square brackets, such as [125]. Excel can display either style. Parentheses are common in accounting and financial reports; square brackets may be required by a particular report template or convention. Choose the exact shape the audience expects, because the two marks are not interchangeable in every context.

A custom number format changes how a value looks in a cell. It does not add brackets to the cell’s underlying value, convert the number to text, or change its sign. If a cell contains -125, the format can display it as (125) or [125], while formulas still use -125. This is useful when you want a polished report without losing the ability to sum, compare, or otherwise calculate with the numbers.

Apply a custom format in Excel for Windows

  1. Select the cells that contain the numbers.
  2. Press Ctrl+1 to open Format Cells. Alternatively, go to Home > Number and select the small dialog box launcher in that group.
  3. Choose the Number tab, then select Custom in the Category list.
  4. Click the Type box, enter a format code, and select OK.

For round parentheses with no decimal places, enter 0;(0). For square brackets, enter 0;\[0\]. If you are using Excel for Mac, Command+1 opens Format Cells; the dialog and the custom-format approach are similar, though the interface can differ slightly by release. In Excel for the web, number-format options may vary with the current interface and account; if the custom format controls you need are unavailable, open the workbook in the desktop app.

How the semicolon sections work

A number format can contain up to four sections separated by semicolons. In order, they specify how to display positive numbers, negative numbers, zero, and text. The negative section is what lets you give negative values their own appearance. With two sections, the first applies to positive values and zero, while the second applies to negative values.

  • 0;(0) displays a positive 125 as 125 and a negative 125 as (125).
  • 0;\[0\] displays the same values as 125 and [125].
  • 0;(0);- displays positives normally, negatives in parentheses, and zero as a dash.
  • 0;(0);-;@ adds a fourth section that displays text as entered.

The format does not need to include a minus sign in the negative section when you use parentheses or brackets. Excel uses that section for a negative value and displays the number according to the pattern you provide. For example, 0;(0) shows -125 as (125), not as (-125). If you actually want both the minus sign and the parentheses, include a minus sign in the negative section, as in 0;(-0).

Choose decimals, separators, and currency symbols

The same section pattern works with thousands separators, decimals, and currency marks. For example, #,##0.00;(#,##0.00) displays 1234.5 as 1,234.50 and -1234.5 as (1,234.50). To use square brackets, write #,##0.00;\[#,##0.00\]. The zero placeholder 0 forces a digit to appear, while the # placeholder displays a digit only when needed. The comma in these examples groups thousands, and the decimal point sets the displayed decimal position.

To add a currency symbol, include it in both sections. For example, $#,##0.00;($#,##0.00) displays a negative amount as ($1,234.50). A format code does not perform currency conversion or establish what currency a value represents; it only adds a display symbol. Depending on the workbook’s locale, Excel may use different punctuation for decimal and thousands separators, so check the result in the actual file rather than assuming every computer will render separators identically.

Set the number of decimal places to match the reporting purpose. A format that shows no decimals rounds the displayed value, but it does not round the stored value. A cell containing 2.75 may appear as (3) under 0;(0), while formulas still use the underlying 2.75. If calculations must use rounded amounts, use an appropriate rounding formula or change the values themselves; changing the display format alone is not enough.

Square brackets have special uses in Excel

Square brackets are not ordinary characters in every part of a custom format. Excel also uses bracketed instructions for color names such as [Red], conditions such as [<0], and elapsed-time formats such as [h]. That is why the square brackets you want printed around a number need to be escaped. In 0;\[0\], the backslashes tell Excel to display the following opening and closing brackets as literal characters.

Parentheses do not need that treatment in the examples above. For an alternative to escaping square brackets, you can place literal characters in quotation marks within a format code. When editing a format, keep the negative pattern after the first semicolon; putting a bracketed color or condition in the wrong place can make Excel interpret it as an instruction instead of printed text. If you are combining colors and literal square brackets, test the complete code on a few positive and negative sample values before applying it to a report.

Use color or a separate zero display

Color can reinforce the negative-value convention, but it is optional. For example, 0;[Red](0) displays negative numbers in red parentheses while leaving positive numbers in the default font color. Excel recognizes a limited set of color names in custom formats, including [Red], [Blue], and [Green]. Color changes the cell’s appearance, not its value, and it should not be the only signal if readers may print in black and white or have difficulty distinguishing colors.

A third section controls zero separately. The code #,##0.00;(#,##0.00);- shows positive and negative values to two decimal places but displays zero as a dash. If you use a three-section format, the sections still follow positive;negative;zero order. A dash can make a report easier to scan, but consider whether readers might mistake it for missing data. A note in the report or a different zero symbol can prevent that ambiguity.

Common problems and how to fix them

  • The brackets appear as an error or do not display. Escape literal square brackets with backslashes, as in 0;\[0\], or put the literal characters in quotation marks.
  • Negative values still show a minus sign. Check that the code has a semicolon and a negative section. A single-section code such as 0 does not define a separate negative appearance.
  • Positive values also show brackets. The format may put the bracket characters in the first section. Use a positive section before the semicolon and the bracketed pattern after it: 0;\[0\].
  • A negative value appears rounded. Check the number of zero placeholders after the decimal point. The display may be rounded even though the stored value has more precision.
  • The format is not taking effect. Confirm that the cell contains a numeric value, not text that merely looks like a number. A number format does not generally transform text into a number.

Also check whether a cell has conditional formatting. Conditional formatting can apply a font color or other appearance that makes the result seem inconsistent with the custom number format. And if a cell shows #####, the column may simply be too narrow to display the formatted value; widen the column before changing the format.

Formats versus changing the actual value

Use a custom number format when the goal is presentation: a report should show negatives in brackets, but calculations should continue to use signed numbers. Use a formula or data-cleaning step only when you intentionally need to change a value or create text. For instance, replacing -125 with the text “[125]” may make that cell unsuitable for ordinary numeric calculations unless it is converted back to a number.

Formatting also applies to cells, not to every possible representation of a number elsewhere. A chart, a copied value, or an exported file may not preserve the cell’s custom display in the way you expect. If you need bracketed text in a document or a data export, check that destination separately. For normal Excel worksheets, however, custom formatting is usually the cleaner choice because the original numeric values remain available.

Frequently Asked Questions

How do I put negative numbers in parentheses in Excel?
Open Format Cells with Ctrl+1, choose Number > Custom, and enter 0;(0). Add commas or decimal placeholders if you want them, such as #,##0.00;(#,##0.00).

How do I show negative numbers in square brackets?
Use a negative section with escaped square brackets, such as 0;\[0\]. For thousands separators and two decimals, use #,##0.00;\[#,##0.00\].

Will brackets change the number used in formulas?
No. Custom number formats change the display only. A cell containing -125 remains -125 for formulas and calculations even when it appears as (125) or [125].

Can I display zero as a dash and negatives in brackets?
Yes. Use three sections, for example 0;\[0\];-. The first section is for positive values, the second for negative values, and the third for zero.

Why does Excel use brackets in other number formats?
Square brackets can mark colors, conditions, or elapsed time in custom formats. Escape brackets intended as visible characters with backslashes, or enclose them in quotation marks, so Excel treats them as text to display.

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.