Closing negative numbers in Excel makes it easier for us to identify negative numbers in data tables and also helps format numbers more professionally. Besides, we can also adjust to highlight negative numbers in Excel such as adding colors to differentiate in the data table. The article below will guide you to close brackets of negative numbers in Excel.
How to close negative number brackets in Excel 2016, 2019
How to close negative numbers in Excel
Step 1:
We also Black out the data area need to close brackets of negative numbers in Excel and then press Right-click and select Format Cells in the displayed list.
Step 2:
Display the formatted custom interface. Friend Click on the Custom line under. Looking at the content next to it, In Type enter #,##0_);(-#,##0) then press Enter.
Then the negative number is bracketed as shown below.
Step 3:
In case you want Add color to distinguish negative numbers In the data table, just add the color to the format range #,##0_);[Red](-#,##0) and click OK.
The result is as shown below.
Step 4:
If you want Add color to positive numbers then enter additional colors into the format range [Green]#,##0_);[Red](-#,##0) and click ok.
Then positive and negative numbers in the Excel table are distinguished by color as shown.
Format negative numbers in Excel brackets
We can format negative numbers in brackets with a format that is completely different from the remaining positive numbers in the Excel table.
Step 1:
First of all you Black out the data area want to format negative numbers in brackets and then look up Number groupclick arrow icon.
Step 2:
In the new interface at Number tabFriend Click Number then looked to the side Click on the round bracket format as shownyou can choose red if you want to highlight negative numbers in the data range. The decimal portion adjusts according to the data you enter in the Excel table.
As a result, you will see negative numbers formatted in brackets and remove the – sign as before, if you want the data table to have the same number display type.
How to create brackets for negative numbers in Excel 2007
Step 1:
First, we will draw a data table and enter numbers into the table with negative number cells. Next, Highlight the column or area that needs to format negative numbers bracketed or highlighted in red. Next, right-click on the highlighted area and select Format Cells...
Step 2:
The Format Cells window interface appears. Select next Number tab. Here, section Category we will select the item Custom. Look to the right of the item Typeyou will find the format #,##0_);(#,##0)then press OK to use.
Step 3:
Immediately after that, all negative numbers in the data table will be obtained Close parenthesis and lose the – sign in front as shown below.
Step 4:
Next if you want Highlight negative numbers in the data table in red while still keeping the – sign in frontwe also Highlight the area you want to format then right click and select Format Cells….
Step 5:
Also on the Number tab, Custom section, we will find the format #,##0_);[Red](-#,##0) in section Type. Press OK to perform.
Noteif the Type section of the Excel version you are using does not have the above format, we can copy and paste that format into the Type section and click OK to apply.
Immediately after that, the negative numbers in the data table were converted to parenthesized format and highlighted in red as shown below.