Show Negative Numbers in Parentheses (Brackets) in Excel (Easy Ways)

Since Excel is used by people in different professions and across industries, Excel allows you to show numbers in many different formats.

When working with financial data and creating accounting reports, one common number format that needs to be used is to show negative numbers in brackets (parentheses).

While the default setting in Excel is to show negative numbers with a minus sign, it’s quite easy to change the format to show negative numbers in brackets/parenthesis.

In this tutorial, I will show you different ways to show negative numbers in brackets. I’ll also cover all the other formatting options that are available to you (such as adding or removing the – or changing the color of the negative or positive numbers)

Show Negative Numbers in Brackets Using In-Built Formats

Excel already has some inbuilt number formats that will show the negative number in brackets.

Below I have a data set where I have the profit values for different stores in column B, and I want to show the negative values in brackets.

Dataset with negative numbers

Here are the steps to do this:

  1. Select the cells that have the numbers (you can select the entire range of cells, not just the negative numbers)
  2. Click the ‘Home’ tab
Click the Home tab
  1. In the ‘Number’ group, click on the dialog box launcher icon (small arrow at the bottom right part of the group)
Click on dialog box launcher
  1. In the ‘Format Cells’ dialog box, within the ‘Number’ tab, select ṭhe third option in the Negative Numbers list (the one that shows the number in the bracket as is in black color)
Select the number format to show negative numbers in brackets
  1. [Optional] Specify the decimal numbers you want to show. In case you don’t want decimal numbers, make the value 0 (it’s 2 by default)
Change the decimal places if needed
  1. Click OK

The above steps would change the format of the cells so that the negative numbers are now shown within parentheses (as shown below).

Final result with negative numbers in bracket

In the ‘Format Cells’ dialog box, you also get the option to have the negative numbers in brackets as well as change the color of these negative numbers to Red.

If you want to show negative numbers in red color within brackets, select the fourth option in step 4.

There is a possibility that you may not see the same ‘Negative numbers’ formatting options as I’ve shown in the screenshots above. Some systems have settings where it does not show the option to format negative numbers to show them in brackets. Instead, it shows the options with the minus sign. In such as case, You will have to change your system settings – as covered later in this tutorial.

Also read: How to Make Negative Numbers Show Up in Red in Excel

Show Negative Numbers in Brackets by Creating a Custom Format

While the above system does allow you to show negative numbers in brackets (in black or red color), in case you need more control on how these numbers should be shown, you can create your own custom number format.

For example, you may want to show the negative numbers in brackets along with a minus sign (or show them in orange/brown color instead of red).

Below, I have a dataset where I have negative numbers and I want to show the negative numbers in brackets along with the minus sign.

Dataset with negative numbers

Below are the steps to do this:

  1. Select the cells that contain the negative numbers that you want to format
  2. Click the ‘Home’ tab
  3. In the ‘Number’ group, click on the dialog box launcher
  4. In the ‘Format Cells’ dialog box, within the ‘Number’ tab, select the ‘Custom’ option
Select the Custom option in Format Cells dialog box
  1. In the ‘Type’ field, enter the below custom format
0;- (0)
Enter the format in the type field
  1. Click OK

The above steps would change the formatting of the cells and the negative numbers would now be shown in brackets along with a minus sign.

Result with negative number in bracket with minus sign

Let me quickly explain how custom number formatting works, and then I will give you some examples of other formats you can use.

In Excel, you can enter the following types of data:

  1. Positive Number
  2. Negative Number
  3. Zero
  4. Text

For any cell, you can specify the format for any of the above data types. This means that I can specify how the positive numbers should be shown in a cell, how the negative numbers should be shown, and how zero and text values should be shown.

And below is how the custom number format should be created

<Format for Positive Number>;<Format for Negative Number>;<Format for Zero>;<Format for Text>

Note that each of these formats is separated by a semi-colon.

If you don’t specify the format for any of these four data types, the ‘General’ format would be used.

In our example, we use the format 0;- (0)

Where:

  • Positive Number format – 0 – This means that the number should be shown as entered
  • Negative Number format – – (0) – This means that the number should be shown as entered within parentheses
  • Zero Format – since this is not specified, it will be taken as General
  • Text format – since this is not specified, it will be taken as General

In this case, since we have made the negative number format as – (#,##0), any negative number would be displayed in a bracket with a negative sign outside the bracket.

Now that you have a basic understanding of how custom number formatting works in Excel, here are some more formats that you can use:

Showing the numbers with thousand separators, and negative numbers in parentheses

#,##0.00;(#,##0.00)
Negative number in bracket with thousand separator

Showing the negative numbers in red color and in parenthesis

#,##0.00;[Red](#,##0.00)
Negative number in red and in bracket

Showing the negative numbers in red color and in parenthesis with a minus sign

#,##0.00;[Red]- (#,##0.00)
Negative number in red with negative sign

Showing the negative numbers in red color positive numbers in Green color

[Green]#,##0.00;[Red]- (#,##0.00)
Positive numbers in green
Also read: Remove Parentheses in Excel

Number Format Not Showing the Parnetheses Option? How to Fix!

When you open the Format Cells dialog box, and select the Number option you see the option to show negative numbers in brackets (as shown below).

Negative number options not showing parentheses

In case you don’t see these options, it could be because of the settings in your system.

Here is how you can change the settings so it shows you the options to format cells so that negative numbers are shown within parentheses:

  1. Open Control Panel on your system
  2. Click on the ‘Change date, time, or number formats’ option
Change date time or number format
  1. In the Region dialog box, click on the ‘Additional Settings’ button
Click on Additional Settings
  1. In the Numbers tab, change the Negative Number format (from the drop-down)
Negative number format
  1. Click OK
  2. Click OK

The above steps would change your system’s setting and you will be able to see the formatting option to show negative numbers in brackets in the Format Cells dialog box.

In this tutorial, I showed you how to change the format of the cells to show negative numbers in brackets. I also covered how you can customize the format to add a minus sign along with the brackets as well as change the color of the negative numbers.

I hope you found this tutorial useful.

Other articles you may also like:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster