To show negative numbers in parentheses in Excel without changing their values, select the cells, press Ctrl+1, choose Number > Custom, and enter #,##0;(#,##0);0 in the Type box. Click OK. The format displays a value such as -1250 as (1,250), while Excel still stores it as a negative number you can use in calculations.
What You’ll Need
- An Excel workbook with numeric values in the cells you want to format. The instructions below are for Microsoft Excel for Microsoft 365 on Windows.
- A preferred display style: choose whether to show decimal places, a currency symbol, and how zero should appear.
No formula or add-in is required. This is a number-formatting change, not a change to the underlying data. Parentheses are sometimes called round brackets; the format below uses them to identify negative values.
Step-by-Step
- Select the cells to format. Click and drag over the range containing the numbers. To format a whole column, click its column letter; to select several separate ranges, hold Ctrl while selecting each range on Windows. Formatting a whole column also affects numbers entered there later, but it can make unrelated numbers in that column display with parentheses too.
- Open Format Cells. Press Ctrl+1 on Windows. Alternatively, go to Home > Number and click the small dialog box launcher at the lower-right of the Number group. On a Mac, Command+1 opens Format Cells in many current Excel versions; if that shortcut is intercepted by macOS or another app, use the ribbon to open the formatting dialog.
- Choose a custom number format. In the Format Cells dialog, open the Number tab and select Custom in the Category list. The Type box shows the selected cells’ existing format. You can replace that code or edit it; copying the current code first is useful if you may want to restore the original appearance later.
- Enter the format code. For whole numbers with a thousands separator, type
#,##0;(#,##0);0into Type. The three sections are separated by semicolons: the first describes positive numbers, the second negative numbers, and the third zero. The parentheses in the second section tell Excel to show negative values inside round brackets. - Apply the format. Click OK. For example, a stored value of -1250 will display as (1,250), 1250 will display as 1,250, and zero will display as 0. Check a negative value in the selected range to confirm that the new appearance is what you intended.
- Choose decimal places if needed. Reopen Format Cells and replace the code with
#,##0.00;(#,##0.00);0.00to display two decimal places. With this format, -1250.5 appears as (1,250.50), 1250.5 as 1,250.50, and zero as 0.00. Use one zero after the decimal point for one displayed decimal, or three zeros for three displayed decimals. - Set zero to display the way you want. The third section controls zero values. In the whole-number code, the final 0 displays zero as 0. To show a dash instead, use
#,##0;(#,##0);-. To leave zero cells visually blank, use#,##0;(#,##0);;. A blank display does not delete the zero or turn it into an empty cell.
In Excel for the web, select the cells and look under Home > Number Format > More Number Formats for the custom-format controls. The available controls can vary by web version or account. If you cannot enter a custom code there, open the workbook in desktop Excel, apply the format, and save it. On a Mac, the Format Cells dialog has the same basic custom-format approach, although ribbon placement and shortcuts can differ slightly.
Common Mistakes
Using square brackets when you mean parentheses. In everyday language, people sometimes use brackets to mean round brackets. The code above produces (1,250), not [1,250]. Excel also uses square brackets for special number-format instructions, so square brackets need to be escaped if you specifically want them displayed. For square brackets around negatives, try #,##0;\[#,##0\];0 in the custom Type box.
Expecting the format to change the stored number. Formatting changes how a value looks, not its sign. A cell containing -25 remains -25, so a sum or other calculation still treats it as negative. If you need to change the underlying data, that is a separate task; do not use a display format as a substitute for correcting an incorrect value.
Entering parentheses as part of the value. Typing text such as (125) into a cell may leave Excel with text rather than a numeric negative value. A number format is the better choice when the value needs to remain available for sorting, totals, and formulas. Enter the actual negative number, such as -125, and let the format show the parentheses.
Forgetting the zero section or decimal places. A custom format with only two sections can use Excel’s default behavior for zero. Including a third section makes the zero display explicit. Also, #,##0 displays no decimal places, even when the stored number has a fraction; Excel rounds the display but does not round the underlying value.
Tips
Keep a copy of the existing format code. If the cells already have a currency, percentage, or other specialized format, replacing it with a basic number code removes that appearance. You can include a currency symbol in all three sections. For a dollar example with two decimal places, enter $#,##0.00;($#,##0.00);$0.00. Change the symbol to suit your workbook and confirm that it matches the currency you intend to show.
Use the right display precision for the task. A report showing whole dollars may be clearer with no decimal places, while a reconciliation may need two. The displayed value can be rounded: a stored value of -12.345 shown with two decimals appears as (12.35), but it is still -12.345 for calculations. If calculations themselves must be rounded, use an appropriate formula separately rather than relying on formatting.
Apply the format consistently. For a table, select the entire value column or relevant range so positive and negative entries use the same separators and decimal places. You can copy a formatted cell and use Paste Special > Formats on another range, but take care not to overwrite the destination cells’ values. A consistent style makes reports easier to scan.
Consider color only if it helps readers. You can add a color to the negative section of a custom format, for example #,##0;[Red](#,##0);0. This displays negative values in red and parentheses in versions that support the color code. Color should be an extra cue, not the only way to distinguish negatives, because printed copies or color-vision differences can make it less reliable.
Troubleshooting
The number still has a minus sign. Reopen Format Cells and check that the code is in the Custom Type box and that its second section is the negative section. The sections must be in positive;negative;zero order. Make sure the code has a semicolon between sections and that you selected the cells you are checking, rather than a neighboring range.
The format has no effect on some cells. Those entries may be stored as text, which number formatting does not change. A common cause is an imported value with a leading apostrophe or an unexpected space. Click a cell and check whether Excel flags it as a number stored as text; if so, use the warning menu’s Convert to Number option when available. For a larger imported range, review the source and use Excel’s data conversion tools carefully before applying the format.
You see hash marks instead of a number. A column that is too narrow can show hash marks when it cannot display the formatted value. Widen the column by dragging the boundary between its heading and the next one, or double-click that boundary to AutoFit. Parentheses and decimal places take extra horizontal space, so a column that fit the old display may no longer fit.
The decimals or zeros look wrong. Check the third section of the format for zero behavior and count the zeros after the decimal point. A code ending in 0.00 requests two displayed decimal places. If the format looks right but a value appears rounded, remember that display rounding does not alter the stored number.
The brackets disappear in a different file type. Formats are part of an Excel workbook, but exporting a sheet as a plain-text CSV does not preserve its number formatting. The displayed parentheses may therefore be absent when you reopen the CSV. Keep an .xlsx copy if you need to retain Excel formatting, or export a PDF when you need a fixed visual report.
Frequently Asked Questions
Does putting a negative number in parentheses make it positive?
No. Parentheses are only the display style. A value displayed as (125) remains -125 in the cell and behaves as a negative number in calculations.
Can I show parentheses and a currency symbol?
Yes. Use a custom format with the symbol in each section. For dollars and two decimal places, $#,##0.00;($#,##0.00);$0.00 displays a negative amount such as -1250.5 as ($1,250.50). Confirm that the chosen symbol and decimal precision suit your data.
Can I show negative numbers in square brackets instead?
Yes. In the Custom Type box, use #,##0;\[#,##0\];0. The backslashes escape the square brackets so Excel displays them as characters rather than interpreting them as format instructions.
Will this work for numbers calculated by formulas?
Yes. If a formula returns a numeric negative result, the cell’s number format displays it in parentheses. The formula remains unchanged; the format affects only what appears in the cell.
Can I remove the parentheses later?
Yes. Select the cells and choose another number format in Home > Number, or reopen Format Cells and select a different category or custom code. Changing the format does not change the values.
Why does Excel show parentheses for zero too?
Check whether the code has a third section after the second semicolon. A custom code’s third section sets the zero display. Use #,##0;(#,##0);0 to show zero without parentheses, or choose a different third section for a dash or blank display.
Related
- How to Indent in Google Sheets: Simple Workarounds
- How to Indent in Microsoft Excel: Cells, Text, and Lists
- How to Indent Text in an Excel Text Box Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Time to Number: Convert Hours, Minutes, and SecondsTo convert an Excel time in A2 to a decimal number, multiply it by the number of units…
- Excel Box Plot With Data Points: How to Show Every ValueYes. In Excel for Microsoft 365 on Windows, select the box-and-whisker chart, open Format Data Series, and under…
- Excel Freeze Panes: Stop Freezing Too Many ColumnsIf Excel freezes too many columns, the freeze boundary is set too far to the right. Choose View…
- Excel Data Bars: What Percent Means and How to Set ItIn Excel for Microsoft 365 on Windows, a data bar’s Percent setting defines a minimum or maximum boundary…
- How to Add or Remove a Draft Watermark in Microsoft WordTo add a Draft watermark in Word for Microsoft 365 on Windows, open the document and choose Design…
- Excel Power Query Best Practices for Reliable DataFor reliable Excel Power Query results, start with a stable source, make each transformation clear and repeatable, assign…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.