Insert 3 Number Zero (000)

[muhammad susanto]

hi all..

how to inserted 3 number zero (000) in a data like this :
<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]my expected[/TH]
[/TR]
</thead><tbody> [TR]
[TD]025040900662063KD[/TD]
[TD]025040900662063000KD[/TD]
[/TR]
[TR]
[TD]066640900673830KD[/TD]
[TD]066640900673830000KP[/TD]
[/TR]
[TR]
[TD]015040900674348KD[/TD]
[TD]etc...[/TD]
[/TR]
[TR]
[TD]042540900675027KD[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


any help, greatly appreciated...

.sst.

 

[fhqwgads]

will your data always have "KD" at the end? you can do a ctrl H find/replace and replace KD with 000KD

 

[jtakw]

Hi,

Why is your 2nd row sample switched from KD to KP?

Assuming that's a typo, and you may have different 2 ( TWO ) characters at the End of the Text string, try this:

Book1
	A	B
1	data
2	025040900662063KD	025040900662063000KD
3	066640900673830KD	066640900673830000KD
4	015040900674348KD	015040900674348000KD
5	042540900675027KD	042540900675027000KD
6	123456789012345XY	123456789012345000XY
Sheet361

Cell Formulas
Range	Formula
B2	=REPLACE(A2,LEN(A2)-1,,"000")

Formula copied down.