Microsoft Excel uses positive and negative numbers in performing mathematical calculations. In Excel, negative numbers are displayed with minus symbols by default. These are the numbers that are lower than 0 in value. Excel makes it easy to recognize the negative numbers by facilitating various best practices. Show It needs to recognize the negative numbers while performing the calculations. In some scenarios, such as determining variance, it is necessary to convert the negative numbers to positive numbers or represent them in an appropriate format to use the negative values appropriately. It is required to represent them by applying a specific conditional formatConditional formatting is a technique in Excel that allows us to format cells in a worksheet based on certain conditions. It can be found in the styles section of the Home tab.read more based on the requirement. The present article aims to identify ways to manage the negative numbers in Excel. Explanation of Negative Numbers in ExcelHandling the negative numbers is very easy in Excel. Excel can manage both positive and negative numbers effectively. But, negative numbers can generate some confusion for the users sometimes. There is a chance for the occurrence of issues while handling negative numbers when the inappropriate format is chosen for them. It displays the errors when a user tries to perform calculations on the negatives. Entering the negative numbers with a minus sign is very easy but analyzing them is tough when a mixture of positive and negative values is presented. To avoid this problem, it needs to change the format of the Excel cells that contain negative values to get accurate results.  You are free to use this image on your website, templates, etc, Please provide us with an attribution link Article Link to be HyperlinkedFor eg: Source: Negative Numbers in Excel (wallstreetmojo.com) How to Show Negative Numbers in Excel?Negative numbers have a lot of significance in handling the various applications in Excel. Therefore, applying the set of formats is important in multiple areas. Top 3 Ways to Show/Highlight Negative Numbers in ExcelThis section will describe the various ways to show/highlight negative numbers in Excel. Example#1 – With Conditional FormattingRepresenting negative numbers with conditional formatting This example illustrates the Excel conditional formatting to highlight the negative numbers in various steps. For this example, we need to use numbers that are lower than 0. The following data is considered to illustrate this example. Step 1: We must first select the entire range of data as shown in the figure. Then, go to the “Home” tab and select conditional formatting. Next, select the “Highlight Cells Rules” and “Less Than” under the options presented. It opens the “Less Than” dialog box, as shown in the figure. Step 2: Enter the value in the empty box under “Format cells that are LESS THAN” and click on the dropdown right to “with’ to apply the desired formatting to the numbers. Ensure that “Light Red Fill with Dark Red Text” is highlighted. Then click on “OK.” The output is shown as, The above figure identifies that the cells with values less than 0 are highlighted with a red fill and red color to text. This type of conditional formatting is also applied with greater than, between, equal to, and duplicate values with negative values. Example#2 – With Inbuilt Number FormattingRepresenting negative numbers with inbuilt number formatting This example is to illustrate the Excel inbuilt number formatting to highlight the negative numbers in red color. For this example, we need to use numbers that are lower than 0. The following are the steps required The following data is considered to illustrate this example. Step 1: Select the data that you want to apply the inbuilt custom formatting with a red color. Step 2:
It helps in opening the “Format Cells” dialog box. Step 3: In the “Format Cells” dialog box, ensure that the “Number” tab is highlighted in the “Format Cells” dialog box. Go to “Number” under the “Number” tab. Select the red text option with brackets for negative numbers on the right side of the options. And click on “OK.” Step 4: The formatted Excel negative numbers will look as follows, Two decimal points are automatically added to numbers when the formatting is applied. Example#3 – With Custom Number FormattingRepresenting negative numbers with custom number formatting This example illustrates the custom number formattingExcel custom number formatting is nothing but making the data look better or visually appealing. Excel has many inbuilt number formatting. On top of this, we can customize the Excel number formatting by changing the format of the numbers.read more to highlight the negative numbers in Excel. For this example, we need to use the numbers which are lower than 0. The following data is considered to illustrate this example. Step 1: We must select the data that we want to apply the inbuilt custom formatting with a red color. Step 2: Go to the “Home” tab.
It helps in opening the “Format Cells” dialog box. Step 3: The dialog box ensures that the “Number” tab is highlighted in the “Format Cells.” Go to the “Custom” option under the “Number” tab. Select the appropriate format, as shown in the figure. Click on “OK” to apply the formatting. Step 4: The negative numbers will look as follows in Excel. Things to Remember
Recommended ArticlesThis article is a guide to Negative Numbers in Excel. We discuss how to show/highlight the negative number in Excel with the help of examples. You can learn more about Excel from the following articles: – |
How to show positive and negative variance in Excel
zusammenhängende Posts
Urheberrechte © © 2024 frojeostern Inc.
