Enter 0 in the Decimal placesbox to avoid decimals. Here weve chosen to display negative values in red with parentheses. An equal sign.
On the Home tab in the Number group click the percentage symbol to apply a Percentage format.
In the Negative Numbers box select the last option as highlighted. Select the range that you will extract text between specified marks and click Kutools Text Extract Text. Create a Custom Negative Number Format. How to display numbers in parentheses in excel.