To show negative numbers in brackets in Excel without changing their values, select the cells, press Ctrl+1, choose Number > Custom, and enter #,##0;(#,##0) in the Type box. Select OK. Negative whole numbers will display in parentheses, while positive numbers remain unchanged. This guide is for Microsoft Excel for Microsoft 365 on Windows; the same custom-format method works in desktop Excel for Mac.
This is a number format, not a formula: the cell still contains the original negative value, so calculations, sorting, and charts can continue to use it as a number. Before applying the format, decide whether the cells need decimal places, a currency symbol, or a special display for zero.
What You’ll Need
- An Excel workbook containing numeric values. The cells can already contain negative numbers, or you can apply the format before entering them.
- Permission to edit the workbook and the range you want to format. If the sheet is protected, you may need the owner to unlock the relevant cells or unprotect the sheet.
- Excel for Microsoft 365 desktop on Windows for the exact steps below. Excel for Mac has the same Format Cells controls, although some keyboard shortcuts differ. Excel for the web can display many custom formats, but if it does not offer a way to create or edit the format, open the workbook in desktop Excel.
Step-by-Step
-
Select the cells to format. Click a cell or drag over the range containing the numbers. To format a whole column, click its letter at the top of the worksheet; to format several separate ranges, hold Ctrl while selecting each range on Windows. If you want the format applied to future entries, select the intended input range as well as the existing values.
Check that your selection does not include headings or notes unless you want to format those too. Number formats affect numeric entries, not ordinary text, but selecting only the intended data makes the result easier to review.
-
Open Format Cells. Press Ctrl+1 on Windows. You can also right-click the selection and choose Format Cells. In Excel for Mac, press Command+1 or use Format > Cells, depending on your version and menu layout. If a laptop requires it, you may need to hold the Fn key while pressing the number key.
-
Choose the Custom category. In the Format Cells dialog, open the Number tab and select Custom from the Category list. The Type box shows the selected cells’ current format code. Replacing the code changes how the selected cells appear, so note the existing setting first if it includes special currency, color, or decimal choices you need to preserve.
-
Enter a format for whole numbers. For comma-grouped whole numbers, enter
#,##0;(#,##0)in the Type box. The part before the semicolon controls positive numbers; the part after it controls negative numbers. The second part places parentheses around the negative number. For example, an underlying value of -1250 displays as (1,250), and a value of 1250 displays as 1,250.If you do not want thousands separators, use
0;(0). If you want one decimal place and grouped thousands, use#,##0.0;(#,##0.0). For two decimal places, use#,##0.00;(#,##0.00). The number of zero placeholders after the decimal point sets the displayed decimal places; it does not round or change the value stored in the cell. -
Check the preview and apply the format. Look at the Sample preview if Excel provides one, then select OK. Inspect both a positive and a negative value in the worksheet. A negative value should have opening and closing parentheses, while a positive value should not. If the results look wrong, reopen Format Cells and check that the semicolon and parentheses are in the correct places.
-
Choose how zeros should appear, if needed. The two-section format above gives positive and negative numbers separate patterns; zero uses the positive pattern and therefore displays as 0. To show zero as a dash while retaining bracketed negatives, enter
#,##0;(#,##0);-. The third section, after the second semicolon, controls zero values. To show zero as 0.00 while keeping two decimal places on other numbers, use#,##0.00;(#,##0.00);0.00. -
Apply an appropriate currency or percentage style when required. For dollars with two decimal places, use
$#,##0.00;($#,##0.00); a value of -1250.5 will display as ($1,250.50). If your workbook uses another currency, substitute its symbol or choose a currency format in the Number tab and then adjust the custom code. For percentages displayed with no decimal places, use0%;(0%). For example, an underlying value of -0.25 displays as (25%). Percentage formatting displays a value multiplied by 100; it does not turn a whole-number value such as -25 into -25%.
Excel uses your regional settings for decimal and thousands separators. If your system expects a comma for decimals or a different grouping symbol, Excel may display or interpret the code differently from the examples. Use the separators shown in your Excel environment, and check the preview before applying a format to a large range.
Common Mistakes
-
Typing parentheses into the cell. Replacing -1250 with the text (1,250) may make it look right, but it can turn a number into text. Formulas may then ignore it, and numeric sorting or charting may not work as expected. Keep the negative value in the cell and use a number format to change its appearance.
-
Putting the format sections in the wrong order. In a custom number format, sections are separated by semicolons. The first section is for positive values and the second is for negative values. If you type
(#,##0);#,##0, you will put brackets on positives rather than negatives. -
Expecting the format to change the value. Brackets are display only. A displayed value of (1,250) still behaves as -1250 in a sum or calculation. If a report needs a positive magnitude instead, that is a different calculation and should not be achieved by number formatting.
-
Using too few or too many decimal placeholders. A format with no decimal places hides fractional digits in the display, while the cell still retains them. A format with two decimal places rounds the display to two places, but the underlying value remains at its original precision.
-
Overwriting a useful existing format. A custom format can replace an existing currency symbol, decimal setting, or negative-number color. If those details matter, incorporate them into the new pattern or note the old format before changing it.
Tips
-
Use a consistent pattern across related figures. Apply the same format to all values in a report column so that a negative figure is not bracketed in one section but shown with a minus sign in another. You can use Format Painter or copy a correctly formatted cell and use Paste Special > Formats on another range.
-
Keep decimal precision appropriate to the data. Counts often use whole numbers, whereas prices and measurements may need one or two decimal places. Choose a display precision that makes the report readable without implying more accuracy than the source data supports.
-
Add color only when it improves readability. For example, a custom pattern such as
#,##0;[Red](#,##0)displays negatives in red brackets. Color is an optional visual cue, not a replacement for the parentheses, and it may be less useful in grayscale printouts or for readers with color-vision differences. -
Test the format on representative values first. Check a large negative, a small negative with decimals, zero, and a positive value. This catches choices such as hidden decimal places or an unexpected zero display before you format a full report.
-
Remember that formats usually travel with the workbook. When you share the file, recipients can see the bracketed display while the cells remain numeric. If you export or copy the values into another application, that application may not preserve Excel’s custom number format.
Troubleshooting
The number still shows a minus sign. Reopen Format Cells and confirm that the custom code has two sections separated by a semicolon, with parentheses in the second section, such as #,##0;(#,##0). Also confirm you formatted the cell that contains the value, rather than a nearby cell or a different range.
The format code is rejected or the separators look different. Check the decimal and thousands separators used by your regional settings. Excel may translate the displayed code or expect different separators. Try entering the pattern in the Custom Type box and use the preview to see whether Excel accepts it. If a copied code includes unusual spaces or typographic characters, replace it with ordinary characters typed directly in the Type box.
Parentheses appear, but the value does not calculate correctly. Select the cell and inspect the formula bar. If the value was entered with parentheses as literal text, or imported with a leading apostrophe, the cell may not be numeric. A number format cannot convert text to a number. Convert the source data to real numbers first, then apply the custom format; check a small sample and preserve a copy of imported data before making bulk changes.
Some cells change and others do not. The unformatted entries may be text, or they may have been excluded from the selection. Check the formula bar and cell alignment, and verify that the range covers all intended rows. If the values are part of an Excel table, apply the format to the table’s entire data column or extend the selection as new rows are added.
The brackets disappear after sharing or exporting. Custom formatting is an Excel display setting, and another app or file format may not support the same pattern. Keep a copy in Excel format when the recipient needs to see the original behavior. If you export to a format that preserves only displayed text, verify the exported file before sending it.
Excel for the web does not offer the Custom option. Open the workbook in the desktop app, apply the format there, and save the workbook. The web version may display the saved custom format even when it does not provide the same controls for creating or editing it.
Frequently Asked Questions
Do brackets change a negative number into a positive number?
No. They change only how the value is displayed. A cell that displays (125) with this format still contains -125 and remains negative in calculations.
Can I show brackets only for negative numbers?
Yes. Use a positive section followed by a negative section, such as #,##0;(#,##0). Positive numbers use the first pattern; negative numbers use the second. You can add a third section if you want a separate display for zero.
Can I use brackets and keep two decimal places?
Yes. Use #,##0.00;(#,##0.00). This displays two decimal places for both positive and negative values, with brackets only around negatives. The underlying values retain their full precision.
Can I bracket negative currency amounts?
Yes. For dollars, a basic two-decimal format is $#,##0.00;($#,##0.00). Replace the currency symbol to suit the workbook, or start with Excel’s currency format and edit the negative pattern. Regional settings and accounting conventions can affect the preferred symbol placement.
Will this work in Excel for Mac?
Yes. Use Format Cells and select Number > Custom, then enter the same format code. Command+1 is the Mac shortcut corresponding to Ctrl+1 on Windows; menu names can vary slightly by Excel version.
Can I make zero display as a dash?
Yes. Add a third section for zero, as in #,##0;(#,##0);-. The first section applies to positive numbers, the second to negative numbers, and the third to zero. Check the preview to confirm the dash suits your report.
Related
- Resize an Image in an Excel Header: Step-by-Step Guide
- Resize a Picture in an Excel Cell: Step-by-Step
- Resize Columns in Excel: Keyboard Shortcuts That Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Drop-Down Lists: How to Add and Manage Them EasilyTo add a drop-down list in Excel for Microsoft 365 on Windows, select the cells, choose Data >…
- Insert Paste Row Shortcut in Excel: Keyboard GuideIn Excel for Microsoft 365 on Windows, copy the row, select the row number where it should go,…
- Excel Data Validation Examples and Setup TipsExcel data validation examples include dropdown lists for status fields, number limits for quantities, date rules for deadlines,…
- Excel File Freezing: Causes and FixesIf an Excel file freezes, first wait briefly and try Ctrl+S; if Excel remains unresponsive, reopen Excel in…
- How to Double Space in Word for the Web, Step by StepTo double-space text in Word for the web, select the text, then choose Home > Line and Paragraph…
- Excel Hide Columns From Certain Users: What Actually WorksNo—not as a user-specific setting. In Excel for Microsoft 365, hiding a column hides it for everyone using…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.