Custom Number Format (2.01.01.03.02.2)

[muhammad susanto]

hi all..

how to make this layout using Custom Number Format :
<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>data</th><th>expected result</th></tr></thead><tbody>
<tr><td>2010103022</td><td>2.01.01.03.02.2</td></tr>
<tr><td>2010103023</td><td>2.01.01.03.02.3</td></tr>
<tr><td>2010103999</td><td>etc..</td></tr>
<tr><td>2010104001</td><td></td></tr>
</tbody></table>

any help, thank in advance..

susanto

 

[jtakw]

Hi,

Book1
	A	B
1	data	expected result
2	2010103022	2.01.01.03.02.2
3	2010103023	2.01.01.03.02.3
4	2010103999	2.01.01.03.99.9
5	2010104001	2.01.01.04.00.1
6
7		Custom format
8		0\.00\.00\.00\.00\.0
Sheet172