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>

typing	target/result
1	+1%
-1	-1%
0	0%
2,5	+2,5%
-2,5	-2,5%

<thead>
</thead><tbody>
</tbody>

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"%"