Custom Number Format Not Work in Decimal Format Percentage

[muhammad susanto]

hi all..

how to make in custom number format e.i
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]typing[/TH]
[TH]target/result[/TH]
[/TR]
</thead><tbody> [TR]
[TD]1[/TD]
[TD]+1%[/TD]
[/TR]
[TR]
[TD]-1[/TD]
[TD]-1%[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]2,5[/TD]
[TD]+2,5%[/TD]
[/TR]
[TR]
[TD]-2,5[/TD]
[TD]-2,5%[/TD]
[/TR]
</tbody>[/TABLE]


i have use : +0%;-0%;0% in custom number format but not fully work for decimal number..
note :
mark (,) as decimal mark not use dot.

any help, thanks in advance..

susanto

 

[yky]

You are using European number format. I can't test on it because I use the US format. The following is what works on the US format. Maybe you can adapt it to European format.

I think you can only have one decimal format. So, you can only have 2.5% and 1.0 % but not 2.5% and 1%.

Please keep in mind that multiplication and division will not work. 1 x 1 =1 but 1% x 1% is not 1%, which is the result if you use this number format.

+#.0"%";-#.0"%";0"%"