Rafi
You may have created datasheet and format numbers in your Excel worksheet. But sometimes your data may contain negative values and you need to show your negative numbers in some other way. If you really need to do so, then you have landed in the right place! In this article, I will show you how to show negative numbers in Excel.
Download Practice Workbook
You can download the practice book from the button below.
Formatting Negative Numbers
Negative numbers are described usually by putting a negative sign (-) at the beginning of a number in an Excel workbook. But Excel also allows you to format the negative numbers on the basis of how you wish to show them on your worksheet. While entering negative values on the worksheet, you just have to put the (-) sign at the start.. And then you can change it as per your choice like parenthesis and color.
4 Quick Tricks to Show Negative Numbers in Excel
In this section, you will find 4 easy and quick tricks to show negative numbers in your Excel workbook. Let’s check them now!
1. Use Number Format to Show Negative Numbers
Let’s say, we have got a dataset of the cash flow statement of a company for 3 consecutive months. The monetary (in USD) value for income of the company is denoted with positive numbers and the outward cash amounts (which decrease the balance) are denoted by negative numbers.
Here, let’s use the Number Format to show negative numbers for our concerning dataset.
For demonstrating this method, proceed with the following steps.
Steps:
- First of all, select the data> right-click on the mouse> select Format Cells.
- Now, the Format Cells dialogue box will appear. Here, from the Number menu, choose Number from the Category box.
- You will see four options for Negative Numbers:
- Negative sign (-) at the beginning
- Red color text
- Enclosed with parenthesis
- Red color text & enclosed with parenthesis
Hence, choose an option from the list (i.e. enclosed with parenthesis)> click OK.
- Here, the selected cells will show the negative numbers enclosed with parenthesis.
By following the steps above, you can quickly format your negative numbers in Excel.
Read More: How to Add Negative Numbers in Excel (4 Easy Ways)
2. Showing Negative Numbers with Custom Format
For our previous set of data, I will now show our negative numbers with a custom format. For executing this method, follow the steps below.
Steps:
- Firstly, select the cells containing the numerical value.
- Then, press CTRL+1 to open the Format Cells dialogue box. Here, from the Number Menu, click Custom from the Category box.
- Now, select a format type and click OK. I have chosen the following:
#,##0_);[Red](#,##0)
- Hence, your cell will show the negative numbers enclosed with parenthesis and red text.
So Excel allows you to customize and show the negative numbers as you want.
Read More: How to Count Negative Numbers in Excel (3 Easy Ways)
3. Use Conditional Formatting to Show Negative Numbers
With the same set of data, I will now show the use of conditional formatting. In order to do so, proceed as the steps below.
Steps:
- First of all, select the numbers.
- Then, go to the Home tab> click Conditional Formatting> select Highlight Cells Rules> choose Less Than.
- Then, a box will show up. Enter 0 in the Format cells that are Less Than box and assign a format (i.e. Red Text) and click OK.
- Finally, your cells will return negative values with red colors.
So, following these steps will allow you to apply conditions and then format your negative numbers.
Read More: Excel Formula to Return Zero If Negative Value is Found
4. Use of Accounting Format for Negative Numbers
If you are dealing with a numerical value that denotes currency, then you can also apply the Accounting Number format. Here, we will now show the trick to use the Accounting Number format for the same set of data as numbers in the data denotes monetary value. In order to demonstrate this method, proceed in the following steps.
Steps:
- Firstly, select the cells, go to the Home tab> click Number Format> select Accounting.
- Hence, your cells will show the negative number enclosed with parenthesis.
So easy, isn’t it? You can format and show your negative numbers in the blink of an eye in this way!
Conclusion
In this article, you have learned how to show negative numbers in Excel. I hope from now on you can quickly show negative numbers in an Excel workbook. If you have better methods, questions, or feedback regarding this article, please don’t forget to share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy. Have a great day!
