Number format in excel Showing value without multiplying with 100

Question

When I set a cell's format to %, it immediately multiplies the value by 100 and displays the result. 5.66 then becomes 566%. I want to apply a % format to a column while keeping the values the same. I only need the value and the percent sign to be displayed. In order to do this, I utilized the format 0.00##%.

The values should be enclosed in brackets, and I now want to display negative values in RED color without the '-' indication (negative). Therefore, -5.66 should be displayed as (5.66%) in red.

Answer 1

You just need to select Custom from the format drop-down menu when you right-click and choose it.

0.00##\%;[Red](0.00##\%)

Your defined format that you supplied makes up the first part of the custom format. Negative integers are used after the semicolon. The commands [RED] and () instruct Excel to highlight the negative integers in red and to surround them in parenthesis, respectively.