title: Number format in excel: Showing % value without multiplying with 100
body: <p>When I set format of a cell as %, it automatically multiply the value with 100 &amp; show the value. So <code>5.66</code> becomes <code>566 %</code>.</p>
  
  <p>I want to apply % format on a column but want to keep the values same as before. I just want % sign to be shown along with the value. To achieve this, I used following format <code>0.00##\%</code></p>
  
  <p>Now I want to show negavtive values in RED color without '-' sign(negative) and the values should be wrapped in brackets. so -5.66 should be shown as (5.66%) in red color.</p>
  
  <p>Please help </p>