Percentage Formating

[luke1438]

I need to format a positive percentage as 0.00% and a negative percentage as (0.00%). There is not a format listed under percentage formating or under the custom formating. Anyone have any suggestions?

Thank you
Luke

 

[shift-del]

Hi Luke

0.00%,(0.00%)

 

[luke1438]

Re: Percentage Formatting - Default?

shift-del's answer works with a minor modification - ";" instead of "," - but it is coming up as bold red. Is there any way to make it black and not bold?

Thanks
Luke

 

[shift-del]

Re: Percentage Formatting - Default?

but it is coming up as bold red.

Maybe the cell is formatted as bold red, because it works allright for me.
<table valign="middle" colspan="2" style="font-family: Calibri; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11px; font-weight: normal; font-style: normal;" border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28pt"><col width="84,75pt"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="2" align="middle">Worksheet 'Tabelle1'</td></tr><tr style="background-color: rgb(202, 202, 202);"><td>
</td><td align="middle">A</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">1</td><td align="right">3,00%</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td align="right">(3,00%)</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</td><td style="color: rgb(255, 0, 0); font-weight: bold;" align="right">3,00%</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">4</td><td style="color: rgb(255, 0, 0); font-weight: bold;" align="right">(3,00%)</td></tr></tbody></table>
<table valign="middle" colspan="3" style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; font-size: 10px;" border="3" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(170, 238, 170);"><td>Cell</td><td>Format</td><td align="right">Value</td></tr><tr><td>A1</td><td>0.00%;(0.00%)</td><td align="right">0,03</td></tr><tr><td>A2</td><td>0.00%;(0.00%)</td><td align="right">-0,03</td></tr><tr><td>A3</td><td>0.00%;(0.00%)</td><td align="right">0,03</td></tr><tr><td>A4</td><td>0.00%;(0.00%)</td><td align="right">-0,03</td></tr></tbody></table><table style="font-family: Arial; font-size: 7pt;"><tbody><tr><td style="color: rgb(51, 51, 51);">Created with Tab2HTML (v2.4.1). ©Gerd alias Bamberg</td></tr></tbody></table>