Display Negative Numbers with a Minus Sign and Parentheses in Excel
Question details
The user wants Excel to display negative numbers with both a minus sign and parentheses across multiple worksheets.

- 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.
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.
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.
On a worksheet, select the numeric cells or range you want to format, including any formulas whose results should use the same display.
Press Ctrl+1, or right-click the selection and choose Format Cells.
On the Number tab, choose Custom and enter General;"-("General")" in the Type box. This displays a negative value such as -123 as -(123).
Click OK, then repeat the selection and formatting on each other worksheet that needs the same display.

Select Numeric Constants with Go To Special
Use this method when you want to format numeric constants without selecting text or other constant types.
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. Open the spreadsheet: Open your workbook in WPS Spreadsheet and select the cells you want to format.
- 2. Open cell formatting: Right-click the selection and choose Format Cells, or press Ctrl+1.
- 3. Set a custom format: Under Number, choose Custom and enter 0.00;"-("0.00")";0.00 in the format field.
- 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.

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.




