It comes from the Number group present under the Home tab. Step 2: Open the Format Cells dialogue box by clicking the icon that is there for number formatting. Step 1: Select all the cells which you wanted to format under Excel. Follow the steps below for better understanding: We can use a custom number formatting of our own to represent the negative numbers. You can see the negative numbers are colored with text color as red. Reduce the Decimal Places: to zero (0) from 2 and Select the last numbering sample, which has a negative sign with it and text color as red under Negative Numbers. Step 4: Once you click on the Number option, on the right-hand side, under the Format Cells window, you can see a sample of the formatting. Under the Number tab, select Category: as Number. If it is not, you need to click on it to select. Step 3: By default, the Number tab is something that gets highlighted inside the Format Cells window out of all six tabs. Here you can format the cells as well as customize the formatting of the cell as per your requirements. See the screenshot below:Ī new window will pop up named Format Cells. Step 2: Navigate to the Home tab under the Excel ribbon and click on the small arrow type of icon, which is there to enlarge the number formatting under the Number group. Step 1: Select all the data from your cells as shown below: Now we will see how to represent the negative numbers with the built-in number formatting in Excel. Where all the negative numbers are colored as Red and cells are colored as light red.Įxample #2 – Negative numbers with Built-in Number Formatting In that box, Put the value as zero (0) within the box under Format cells that are Less Than and select appropriate cells as well as text color through the dropdown menu on the right.Ĭlick the OK button, and you can see the result as below. Step 4: A new dialog box Less Than opens up.

Excel negative percentage parentheses