Adding Number 0 and mark "-" in One Cell.

[muhammad susanto]

hi all...

how to adding 0 and mark "-" without helper column...
this layout :
<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>data</th><th>after formula</th></tr></thead><tbody>
<tr><td>5010101001</td><td>1</td><td>5010101001-001</td></tr>
<tr><td>5010101006</td><td>4</td><td>5010101006-004</td></tr>
<tr><td>5010101007</td><td>45</td><td>5010101007-045</td></tr>
<tr><td>5010101012</td><td>126</td><td>5010101012-126</td></tr>
</tbody></table>

any help is greatly appreciated...

m.susanto<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>

 

[jtakw]

Hi,

Do you mean something like this:

Excel 2010
	A	B	C
1	data	data	after formula
2	5010101001	1	5010101001-001
3	5010101006	4	5010101006-004
4	5010101007	45	5010101007-045
5	5010101012	126	5010101012-126
Sheet1

Cell Formulas
Range	Formula
C2	=A2&TEXT(B2,"-000")

C2 formula copied down.

 

[muhammad susanto]

thank you..

 

[jtakw]

You're welcome.