To show negative numbers in parentheses in Excel, select the cells, press Ctrl+1, choose Number > Custom, and enter a format such as #,##0;(#,##0). The value remains negative; only the way Excel displays it changes.
What a parentheses number format does
Parentheses are a common accounting and reporting convention for negative amounts. For example, a stored value of -1250 can appear as (1,250), making it visually distinct from a positive 1,250 without adding a minus sign. Excel still treats the cell as a number, so you can add it, subtract it, sort it, and use it in formulas as usual.
A number format controls presentation, not the underlying data. The formula bar continues to show the value or formula, and a formula such as SUM includes the negative value normally. If another workbook or program reads the numeric cell, it receives a negative number rather than text containing parentheses. This is why formatting is usually preferable to editing values or using a formula to turn a number into a text string.
Apply the format in Excel for Windows
In Excel for Microsoft 365 on Windows, use these steps to format a range:
- Select the cells you want to change. You can select a whole column if future entries in that column should use the same display.
- Press Ctrl+1 to open the Format Cells dialog. Alternatively, on the Home tab, open the Number group’s dialog launcher.
- On the Number tab, select Custom from the Category list.
- Click or select the Type box, enter
#,##0;(#,##0), and select OK.
The first part of this example displays positive numbers with a thousands separator and no decimal places. The second part displays negative numbers in parentheses. For instance, 1250 appears as 1,250 and -1250 appears as (1,250). On Excel for Mac, Command+1 opens Format Cells; the same Custom category and format code are available, though dialog details can vary slightly by release. Excel for the web may not provide the same full custom-format editing controls as the desktop app, so create or edit a complex format in desktop Excel if the option is unavailable.
Choose a format code for your data
Custom number formats use semicolons to separate sections. A practical format for common numeric data is #,##0.00;(#,##0.00);0.00;@. It shows positive and negative numbers to two decimal places, puts negative values in parentheses, displays zero as 0.00, and leaves text as text. Here are other useful patterns:
0; (0)displays whole numbers, including a space before the negative number in parentheses. If you do not want that space, use0;(0).#,##0.00;(#,##0.00)shows two decimal places and a thousands separator for positive and negative values. Zero uses the first section and appears as 0.00.$#,##0.00;($#,##0.00)adds a dollar sign. Use the appropriate currency symbol for the data and your reporting needs.#,##0;(#,##0);"-"displays whole numbers, parentheses for negatives, and a dash for zero.#,##0.00;[Red](#,##0.00);0.00;@displays negative values in red as well as in parentheses, where the color code is supported by Excel.
In these codes, 0 is a required digit placeholder: Excel displays a zero in that position when a value has no digit there. The # placeholder is optional, so it does not force an unnecessary zero. The comma separates thousands in the examples, while the period marks decimals. Excel may display separators according to the computer’s regional settings, even when the code is entered using the usual format-code notation.
Understand the sections and placeholders
A custom number format can contain as many as four sections, separated by semicolons. Their standard order is positive numbers; negative numbers; zero; text. With two sections, the first applies to positive numbers and zero, and the second applies to negative numbers. With three, you can set separate displays for positive values, negatives, and zero. A fourth section can specify how text is displayed, using the @ placeholder.
That means #,##0;(#,##0) does not define a special zero display. Zero uses the first section and appears as 0. To show a dash for zero, add a third section, as in #,##0;(#,##0);"-". To hide zeros instead, leave the third section empty: #,##0;(#,##0);. Hiding a displayed zero does not delete the value or make it blank for calculations; it can still affect formulas and charts.
Parentheses in the negative section are ordinary characters in the display pattern. They do not turn the value positive or perform arithmetic. You can combine them with currency symbols, decimal places, or color codes, but the section order matters. If you use bracketed conditions such as [Red] or a condition that selects a section based on the value, the format can become more specialized; check the result with positive, negative, and zero examples before applying it broadly.
Decide whether to use parentheses, a minus sign, or a built-in format
For a one-off report, Excel’s built-in Number or Currency formats may already offer negative-number options that use parentheses. Select the cells, open Format Cells, and inspect the choices in the Number or Currency category. The available choices can differ with the category, locale, and Excel version. Built-in formats are quick to apply and can be easier for colleagues to recognize in the dialog.
A custom format is useful when you need a consistent pattern across workbooks, a particular number of decimal places, a custom zero display, or a currency symbol combined with parentheses. It also lets you specify red negatives if that is appropriate for the report. A minus sign, such as -1,250, may be clearer in operational tables where readers expect conventional signed numbers. Parentheses are often used in financial statements, but the right choice depends on the audience and the conventions of the report.
Be consistent within a table. If one column uses parentheses and another uses minus signs for the same kind of measure, readers may wonder whether the numbers mean different things. Use a heading or note if the reporting convention is not obvious, especially when a workbook will be printed or shared outside your team.
Formatting does not round or change calculations
Decimal places in a format control how many digits are displayed, not how Excel stores the number. For example, a value such as -12.345 formatted with two decimal places appears as (12.35), but the stored value remains -12.345. Calculations use the stored value unless a formula explicitly rounds it. That can make a displayed total differ slightly from the sum of the rounded figures readers see on screen.
If the business rule requires rounding the actual result, use a suitable rounding formula in the calculation rather than relying on the number format. Otherwise, keep the full precision and explain that displayed figures are rounded when that distinction matters. Also note that a small negative number can look like zero when the format has few decimal places; with a parentheses format it may appear as (0). Add decimal places or use a more suitable display rule if that could confuse readers.
Common problems and how to fix them
- The cell still shows a minus sign. Check that the negative section comes after the first semicolon and that you selected the intended cells. A one-section pattern such as
#,##0applies to all numbers, so it does not provide a separate negative display. - Parentheses appear around positive numbers too. The section separator may be missing or placed incorrectly. Use
#,##0;(#,##0)and test with both a positive and a negative value. - The number displays as text or will not calculate. A custom number format cannot convert text into a numeric value. If imported data contains text such as “(1,250)” rather than a true negative number, first convert or clean the data; changing its number format alone will not make it numeric.
- Zero is not displayed as expected. With one or two sections, zero uses the positive section. Add a third section to show a dash, blank, or another zero display.
- Decimals appear to be missing. Confirm that the code includes decimal placeholders, such as
0.00. Also check that the cell is wide enough; a narrow column can show number signs instead of the formatted value. - Parentheses appear but the total seems unchanged. That is expected. Formatting changes appearance only; the negative number remains negative and contributes its signed value to calculations.
When troubleshooting, use a few test cells containing a positive number, a negative number, zero, and a small decimal. This quickly reveals whether the format handles the cases you care about. If the same code works in one cell but not another, check for text values, conditional formatting that changes appearance, or a different number format applied to the other cell.
Reuse the format in a workbook
Once a custom format is applied, you can reuse it within the workbook. The format usually becomes available in the Custom list in Format Cells. You can also copy a correctly formatted cell and use Paste Special > Formats to apply its formatting to other cells without replacing their values. The Format Painter is another option for copying appearance, but take care not to overwrite data when using ordinary paste.
For a column that will receive new entries, format the whole intended range in advance. If you use an Excel table, new rows often inherit formatting from the table column, but verify the result when the workbook has special styles or mixed formats. When sharing a workbook, remember that a custom format is stored with the workbook, while regional settings can affect how separators and currency conventions appear on another computer.
Frequently Asked Questions
Can I show negative numbers in parentheses without changing their values?
Yes. Apply a custom number format such as #,##0;(#,##0). The cell remains a negative number and continues to work in arithmetic and formulas.
How do I show dollars and negative values in parentheses?
Use a pattern such as $#,##0.00;($#,##0.00) for dollars and two decimal places. Choose the currency symbol and precision that match your data and report.
How can I display zero as a dash?
Add a third, zero section, for example #,##0;(#,##0);"-". The actual cell value remains zero even though the display is a dash.
Why does Excel still use the negative number in a total?
Because the parentheses are a visual convention created by formatting. The underlying value is still negative, so formulas use it as a negative number.
Can I use parentheses for negative percentages?
Yes. A format such as 0.0%;(0.0%) displays percentages to one decimal place, with negative percentages in parentheses. A stored value of -0.125, for example, displays as (12.5%).
Related
- Excel Shortcut to Insert a Copied Row Without Replacing Data
- Excel Keyboard Shortcut to Rename a Sheet in Windows
- Excel Redo Shortcut: How to Reapply an Action
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Inventory Spreadsheets: Best Practices That Prevent ErrorsGood inventory spreadsheets use one row per item, a unique identifier for each item, consistent fields, and a…
- Create a Page Template in Word and Save It for ReuseTo create a page template in Word, set up a blank document with the page size, margins, headers,…
- Create a Signature File in Outlook: Step-by-Step GuideTo create a signature file in classic Outlook for Windows, make the signature in Outlook first, then open…
- Excel Find and Replace Wildcards: A Practical GuideYes. In Excel for Microsoft 365 on Windows, press Ctrl+H, enter a pattern in Find what, and use…
- Conditional Formatting: Compare Two Columns in ExcelYes. In Excel for Microsoft 365, select the cells you want formatted, choose Home > Conditional Formatting >…
- Excel Find Maximum Value Based on Criteria with MAXIFSTo find the largest value that meets a condition in Excel, use MAXIFS. For example, with regions in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.