# Displaying Negative Numbers in Parentheses in Excel

Last Updated on 01/05/2024

This article will show you how to display negative numbers in parentheses in Excel

Here, we will start with an Excel number format that manages positive and negative numbers.

2. Understanding how to customize a number in Excel

There are four situations you can customize

3. Add parentheses only for negative numbers

Once you understand how to customize a number in Excel, adding the parentheses for negative numbers is easy.

## Negative numbers in Excel

In Excel, the fundamental way to format negative numbers is to use the Accounting number format. This option will display your negative numbers in red 👍

However, negative numbers must be displayed in parentheses for some reports. Let's see how to do that.

## Open the Custom number format in Excel

We must create a custom number format to show negative numbers with parentheses.

• Open the dialog box "Format Cells" using the shortcut Ctrl + 1
• Or by clicking on the last option in the Number Format dropdown list in the Home tab.

## Understand how to customize numbers in Excel

### Excel offers four displays for numbers in this order

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

Positive value;Negative value;Zero;Text

### Specify the display of leading zero

Then, you must to specify the display format for the number, and there are two symbols associated with the numbers.

• Use 0 to display all the 0 (important to keep the leading 0)
• Use # to display the numbers except the 0 if not necessary

For instance, if you have the number 12345, you can display it as follows

• When you use 0, Excel displays the information even if it's not necessary (rows 5 and 6)
• When you use #, Excel manages the leading 0 or doesn't display a value (rows 3 and 4)
• On the opposite, to avoid having no number before the decimal separator (row 8), it's recommended to always write your code like in row 9

## Custom Code to return negative number in parentheses

To represent negative numbers with parentheses, you must modify the code accordingly.

• For the positive number: #,##0.00
• For the negative number in parentheses: (#,##0.00)

So, the code you need to enter in the "Type" field is:

The display of negative numbers is now in parentheses 😀😎😍

You can improve the display by adding the red color for negative numbers with the option [red]

## Frédéric LE GUEN

17/07/2023 @ 11:27

All this is fine but it does not seem to work in windows 11. Previously it was possible to change the negative format in numbers or accounting via the Global options in settings. I cannot find it in the Global settings in W11. I get the use of the custom format but I really do not want to have to resort to that every time I get a negative number, nor do wish to use custom format for all my accounts work, where negatives come up frequently. I am very new to W11 and would appreciate how to dela with this problem. It was so simple in 10 and earlier

2. Michelle Low
14/09/2021 @ 02:55

Thanks !! This solved the problem !

30/08/2021 @ 12:01

The problem usually is that the standard format defined in the system settings for Negative Numbers is without the (parenthesis). The solution is simple: update the system settings.

4. Rob
26/05/2021 @ 15:40

Is there a way to save this format in Excel so it can be used again?

• RK
01/08/2021 @ 04:45

The format will be auto saved, unless you delete. (For all higher versions of excel after 2007)

5. AndyR
19/04/2021 @ 14:41

Is there a way to do this so that the decimal points are all lined up in the column? In your example the negative numbers are slightly out of line because of the close-parenthesis.

• John
09/05/2021 @ 19:49

To line up the decimal point you need to put a space before the ";" in which ever number format you are using.

For example:-

#,##0.00;[Red]-#.##0.00 (already in Custom format list will become

#,##0.00 ;[Red](#.##0.00)

Hope this helps

6. ARKOM
23/12/2020 @ 05:20

Hi Frederic,

DO you know how to fix if the sample number is not showing ?

• Frédéric LE GUEN
12/01/2021 @ 08:33

No

7. Abdul Muhaimin bin Mohd Zamri
10/11/2020 @ 11:36

THANKSSSSS, SO HELPFUL SINCE MY EXCEL DIDNT HAVE THAT IN THE NUMBER FORMAT :')

8. EUGENIO BULLA
26/02/2020 @ 23:50

In all new excel we will need to create this code?
Is there any way to save this code permanently in my Excel 2016 costum options?

9. DIAMOND KARIM
15/11/2019 @ 23:41

Once we put ( ) in negative number sign how can we save it so is permanent. Thank you.

• Frédéric LE GUEN
26/11/2019 @ 15:04

You mean for all your workbook when you create a new one ?

• Tawanda
20/02/2021 @ 18:00

yes

# Displaying Negative Numbers in Parentheses in Excel

Last Updated on 01/05/2024

This article will show you how to display negative numbers in parentheses in Excel

Here, we will start with an Excel number format that manages positive and negative numbers.

2. Understanding how to customize a number in Excel

There are four situations you can customize

3. Add parentheses only for negative numbers

Once you understand how to customize a number in Excel, adding the parentheses for negative numbers is easy.

## Negative numbers in Excel

In Excel, the fundamental way to format negative numbers is to use the Accounting number format. This option will display your negative numbers in red 👍

However, negative numbers must be displayed in parentheses for some reports. Let's see how to do that.

## Open the Custom number format in Excel

We must create a custom number format to show negative numbers with parentheses.

• Open the dialog box "Format Cells" using the shortcut Ctrl + 1
• Or by clicking on the last option in the Number Format dropdown list in the Home tab.

## Understand how to customize numbers in Excel

### Excel offers four displays for numbers in this order

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

Positive value;Negative value;Zero;Text

### Specify the display of leading zero

Then, you must to specify the display format for the number, and there are two symbols associated with the numbers.

• Use 0 to display all the 0 (important to keep the leading 0)
• Use # to display the numbers except the 0 if not necessary

For instance, if you have the number 12345, you can display it as follows

• When you use 0, Excel displays the information even if it's not necessary (rows 5 and 6)
• When you use #, Excel manages the leading 0 or doesn't display a value (rows 3 and 4)
• On the opposite, to avoid having no number before the decimal separator (row 8), it's recommended to always write your code like in row 9

## Custom Code to return negative number in parentheses

To represent negative numbers with parentheses, you must modify the code accordingly.

• For the positive number: #,##0.00
• For the negative number in parentheses: (#,##0.00)

So, the code you need to enter in the "Type" field is:

The display of negative numbers is now in parentheses 😀😎😍

You can improve the display by adding the red color for negative numbers with the option [red]

17/07/2023 @ 11:27

All this is fine but it does not seem to work in windows 11. Previously it was possible to change the negative format in numbers or accounting via the Global options in settings. I cannot find it in the Global settings in W11. I get the use of the custom format but I really do not want to have to resort to that every time I get a negative number, nor do wish to use custom format for all my accounts work, where negatives come up frequently. I am very new to W11 and would appreciate how to dela with this problem. It was so simple in 10 and earlier

2. Michelle Low
14/09/2021 @ 02:55

Thanks !! This solved the problem !

30/08/2021 @ 12:01

The problem usually is that the standard format defined in the system settings for Negative Numbers is without the (parenthesis). The solution is simple: update the system settings.

4. Rob
26/05/2021 @ 15:40

Is there a way to save this format in Excel so it can be used again?

• RK
01/08/2021 @ 04:45

The format will be auto saved, unless you delete. (For all higher versions of excel after 2007)

5. AndyR
19/04/2021 @ 14:41

Is there a way to do this so that the decimal points are all lined up in the column? In your example the negative numbers are slightly out of line because of the close-parenthesis.

• John
09/05/2021 @ 19:49

To line up the decimal point you need to put a space before the ";" in which ever number format you are using.

For example:-

#,##0.00;[Red]-#.##0.00 (already in Custom format list will become

#,##0.00 ;[Red](#.##0.00)

Hope this helps

6. ARKOM
23/12/2020 @ 05:20

Hi Frederic,

DO you know how to fix if the sample number is not showing ?

• Frédéric LE GUEN
12/01/2021 @ 08:33

No

7. Abdul Muhaimin bin Mohd Zamri
10/11/2020 @ 11:36

THANKSSSSS, SO HELPFUL SINCE MY EXCEL DIDNT HAVE THAT IN THE NUMBER FORMAT :')

8. EUGENIO BULLA
26/02/2020 @ 23:50

In all new excel we will need to create this code?
Is there any way to save this code permanently in my Excel 2016 costum options?

9. DIAMOND KARIM
15/11/2019 @ 23:41

Once we put ( ) in negative number sign how can we save it so is permanent. Thank you.

• Frédéric LE GUEN
26/11/2019 @ 15:04

You mean for all your workbook when you create a new one ?

• Tawanda
20/02/2021 @ 18:00

yes