Thứ Sáu, Tháng Hai 7, 2025
spot_img
HomeFinanceInstructions for closing negative number brackets in Excel

Instructions for closing negative number brackets in Excel

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.

Adjust formatting in Excel

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.

Format Excel negative numbers

Then the negative number is bracketed as shown below.

Close brackets of Excel negative numbers

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.

Excel negative number color format

The result is as shown below.

Close brackets of negative numbers in Excel color

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.

Excel positive number color format

Then positive and negative numbers in the Excel table are distinguished by color as shown.

Excel negative and positive number color format

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.

Xem thêm  How to download certificates and certificates of merit Trang Nguyen Vietnamese

Format numbers in Excel

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.

Format brackets for negative numbers in Excel

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.

Format negative numbers in Excel brackets

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...

Close brackets of negative numbers in Excel

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.

Close brackets of negative numbers in Excel

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.

Close brackets of negative numbers in Excel

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….

Close brackets of negative numbers in Excel

Step 5:

Also on the Number tab, Custom section, we will find the format #,##0_);[Red](-#,##0) in section Type. Press OK to perform.

Xem thêm  Instructions for verifying Facebook account identity

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.

Close brackets of negative numbers in Excel

Immediately after that, the negative numbers in the data table were converted to parenthesized format and highlighted in red as shown below.

Close brackets of negative numbers in Excel

Video tutorial on creating Excel negative number brackets

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments