To show negative values in parentheses in Excel, apply a custom number format such as #,##0;(#,##0); to show them in red parentheses, use #,##0;[Red](#,##0). The semicolon separates the positive and negative formats, while brackets have special meanings such as color or conditions—they are not, by themselves, a general instruction to mark a number as negative.
What brackets mean in an Excel number format
In a custom number format, square brackets are used for particular format instructions. For example, [Red] requests red font for values using that section, and [<0] is a condition that applies a section when a value is less than zero. Brackets can also appear in codes for currencies or locale settings. Their meaning depends on what is inside them.
Parentheses are different: they are ordinary characters you can use in a number display. In #,##0;(#,##0), the parentheses in the second section tell Excel to put displayed negative numbers in parentheses. They do not mean the same thing as square brackets, and they do not turn a positive value into a negative one.
This distinction matters because a cell’s number format changes how its value looks, not the underlying value. A cell containing -1250 still contains -1250 when displayed as (1,250). Calculations, sorting, and comparisons continue to use the actual negative number.
How semicolon sections control negative values
Excel custom formats can contain up to four sections, separated by semicolons. In the usual format without conditions, the sections apply in this order:
- First section: positive numbers.
- Second section: negative numbers.
- Third section: zero.
- Fourth section: text.
For example, #,##0;(#,##0) uses a thousands separator and no decimal places. The first section displays 1250 as 1,250, while the second displays -1250 as (1,250). If you add a third section, #,##0;(#,##0);"-", zero is displayed as a dash. The dash is quoted as a literal character; zero remains zero in the cell.
When a format has only two sections, the first section generally covers positive numbers and zero, while the second covers negative numbers. A one-section format applies to all numeric values. A four-section format includes a separate text section, which can be useful in templates, but it is not needed just to format negatives. The semicolons separate display rules; they are not typed into the worksheet cell.
Apply a negative-number format in Excel
In Excel for Microsoft 365 on Windows, select the cells you want to change, open Format Cells with Ctrl+1, and choose the Number tab. Select Custom in the Category list, enter a format code in the Type box, and choose OK. For example, enter #,##0;(#,##0) to show whole numbers with comma grouping and negative values in parentheses.
- Select the target cells or range.
- Press Ctrl+1, or open the Format Cells dialog from the Number group on the Home tab.
- Choose Custom, then enter or edit the code in Type.
- Check the sample preview, and select OK.
On Excel for 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 ribbon layout can differ slightly by platform or window size. In Excel for the web, custom number-format options may depend on the available interface; if you cannot enter the code there, open the workbook in the desktop app.
To change only the appearance for a quick, standard choice, the Number group on the Home tab also has number-format controls. The built-in negative-number choices depend on the selected number category and locale. A custom format is more precise when you want a particular combination, such as parentheses, a thousands separator, and a specific number of decimal places.
Choose a format for decimals, currency, and percentages
Match the code to what the values represent and how much precision readers need. The format does not round the stored number, but it can round what is shown. For instance, a value of -12.345 displayed with two decimal places appears as (12.35); its underlying value is still -12.345.
- Whole numbers:
#,##0;(#,##0)displays -2500 as (2,500). - Two decimal places:
#,##0.00;(#,##0.00)displays -2500.5 as (2,500.50). - Red negatives:
#,##0;[Red](#,##0)displays negative values in red parentheses. - Percentages:
0.0%;(0.0%)displays a value of -0.125 as (12.5%). - Currency:
$#,##0.00;($#,##0.00)displays a negative amount with a dollar sign and parentheses.
Currency symbols and separators can vary by region, so a typed dollar sign is not a universal currency setting. If a workbook will be used in different locales, choose a currency format that matches the intended currency and check how it displays on the recipient’s system. Likewise, percentage formatting scales the displayed value by 100: a stored value of -0.125 is shown as -12.5% when formatted as a percentage.
Use brackets for color or conditions
A bracketed color code can be placed in the negative section to distinguish losses or adjustments visually. For example, #,##0;[Red](#,##0) applies red font to negative values formatted with parentheses. Excel’s recognized color names include Black, Blue, Cyan, Green, Magenta, Red, White, and Yellow. The code affects font color, not cell fill, and it does not alter the value.
Conditions in brackets are another feature. A code such as [<0] expresses a test on the value, rather than specifying a color or adding parentheses. Conditional custom formats can be useful when display rules depend on thresholds, but they are not the simplest choice for the ordinary task of displaying all negative numbers in parentheses. For that, the positive-and-negative two-section pattern is easier to read and maintain.
Do not treat every bracketed expression as interchangeable. [Red] is a color instruction, [<0] is a condition, and parentheses in a number section are literal display characters. Currency and locale codes can also use square brackets. If you inherit an unfamiliar format, inspect its sections and bracket contents before changing it.
Formatting versus changing the number
A common misconception is that adding parentheses changes a negative into a positive, or that removing the minus sign changes the cell’s arithmetic. Number formatting is visual only. For a cell whose stored value is -250, #,##0;(#,##0) displays (250), but a calculation that adds that cell still uses -250.
For the same reason, formatting a positive value to look like a negative is not a sound way to change its meaning. If data needs to be converted, use an appropriate calculation or correct the source data; do not rely on a display code. A format can also hide detail by rounding or suppressing zeros, so check the formula bar or the Number format when the displayed value seems inconsistent with a calculation.
Common problems and how to fix them
- Parentheses do not appear: Confirm the code has a semicolon and that the parentheses are in the negative section, such as
0;(0). A format with only one section does not define a separate negative display. - Negative values still appear with a minus sign: Check whether the format code is valid and applied to the intended cells. A built-in format or a different custom code may be in use.
- Only some cells change: The range may contain cells with different formats, or the selection may not include every relevant cell. Select the full range and reapply the code.
- Values look rounded: Increase the number of decimal places in both sections, for example by using
0.000;(0.000). - Color is not as expected: Verify that
[Red]is in the section used for negative values. Also check whether another formatting rule, such as conditional formatting, affects the cell’s appearance. - Format code appears as text: Enter it in Format Cells under Custom, not into the worksheet as cell content. If the cell itself contains a text value rather than a number, numeric formatting will not make it behave like a number.
Custom formats are associated with the workbook and can be reused on other cells. If a workbook is shared, a recipient may see the same underlying values but should still verify that the display is clear in their version and regional settings. For reports where color is important, keep the symbols or parentheses as well; color alone may not be visible in a printout or to someone viewing the sheet without color.
Frequently Asked Questions
What is the Excel format code for negative numbers in parentheses?
Use a two-section code such as #,##0;(#,##0) for whole numbers, or 0.00;(0.00) for two decimal places. The section after the semicolon controls negative values.
Do I put brackets around a negative number format?
No. Square brackets are not required to show negatives in parentheses. Use parentheses as display characters in the negative section; brackets are reserved for instructions such as colors, conditions, and certain locale codes.
How do I make negative numbers red in Excel?
Use a custom code such as #,##0;[Red]-#,##0 for a minus sign, or #,##0;[Red](#,##0) for parentheses. Select the cells, open Format Cells, and enter the code under Number > Custom.
Will this change the value used in formulas?
No. A custom number format changes the display only. A cell containing -250 remains -250 for formulas, even if it appears as (250).
How do I show zero as a dash but keep negatives in parentheses?
Use three sections, for example #,##0;(#,##0);"-". The first section is for positive values, the second for negative values, and the third for zero.
Related
- Excel: How to Insert an Image in a Header on Every Page
- Excel: How to Count Text vs. Numbers in a Range Correctly
- Excel Data Validation Lists: How to Change or Edit Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Remove Duplicates in Excel Files on SharePointTo remove duplicates from an Excel workbook stored in SharePoint, open the workbook in Excel, select the full…
- Excel Number Format to Hide Zeros Without Changing ValuesYes. In Excel for Microsoft 365 on Windows, apply a custom number format with an empty zero section,…
- Convert Text to Numbers in Excel in BulkTo convert text-stored values to numbers in bulk in Excel for Microsoft 365 on Windows, select the cells…
- Excel Alt+H,O,I: AutoFit Column Width Shortcut GuideIn Excel for Microsoft 365 on Windows, Alt, H, O, I runs AutoFit Column Width for the selected…
- Google Sheets Filter: Find Cells Containing TextYes. In Google Sheets, select your data, choose Data > Create a filter, open the filter menu on…
- How to Combine Multiple Excel Files with Power QueryThe easiest way to combine multiple Excel files in Microsoft 365 on Windows is Power Query: put the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.