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.