Formatting Issues

Display Negative Numbers with a Minus Sign and Parentheses in Excel

Amos GikundaAmos Gikunda Nov 20, 2026 869 views

Question details

The user wants Excel to display negative numbers with both a minus sign and parentheses across multiple worksheets.

Display Negative Numbers with a Minus Sign and Parentheses in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Format numeric cells on one or more worksheets using a display style not offered by the standard regional settings.
Observed behavior
Negative values should appear with a minus sign and parentheses without changing the underlying numbers.
Before you start

Identify the cells or ranges to format and decide whether the minus sign should appear outside or inside the parentheses. If your ranges include formulas, select them directly rather than relying only on numeric constants.

Solution 1Recommended

Apply a Custom Number Format in Excel

Use this method to display negative values with a minus sign and parentheses while leaving the stored values unchanged.

1
Select the cells

On a worksheet, select the numeric cells or range you want to format, including any formulas whose results should use the same display.

2
Open Format Cells

Press Ctrl+1, or right-click the selection and choose Format Cells.

3
Enter the format

On the Number tab, choose Custom and enter General;"-("General")" in the Type box. This displays a negative value such as -123 as -(123).

4
Apply and repeat

Click OK, then repeat the selection and formatting on each other worksheet that needs the same display.

Apply a Custom Number Format in Excel
Adjust the display: To place the minus sign inside the parentheses, use General;"(-"General")" instead. For two decimal places, use 0.00;"-("0.00")";0.00.
Format numbers in WPS Spreadsheet

Display Negative Numbers with Parentheses in WPS Spreadsheet

Use a custom number format in WPS Spreadsheet to show negative values with a minus sign and parentheses without changing the underlying numbers.

  1. 1. Open the spreadsheet: Open your workbook in WPS Spreadsheet and select the cells you want to format.
  2. 2. Open cell formatting: Right-click the selection and choose Format Cells, or press Ctrl+1.
  3. 3. Set a custom format: Under Number, choose Custom and enter 0.00;"-("0.00")";0.00 in the format field.
  4. 4. Apply the format: Click OK, then repeat on other worksheets as needed. Negative values will display with a minus sign outside the parentheses and two decimal places.
Customize the display of negative numbersOpen and edit Microsoft Excel XLS and XLSX filesWork with a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Can I put the minus sign inside the parentheses?

Yes. In Excel, open Format Cells > Number > Custom and enter General;"(-"General")" to display a negative value such as -123 as (-123).

Does a custom number format change the actual cell value?

No. The format changes only how the value is displayed; calculations continue to use the underlying number.

How do I show two decimal places for negative numbers?

In Format Cells > Number > Custom, enter 0.00;"-("0.00")";0.00. For example, -12.5 displays as -(12.50).

Why were formula results not formatted after I used Go To Special?

The Constants option selects fixed values, not formulas. Select the formula cells separately and apply the same custom format through Format Cells > Number > Custom.