Convert Text to Real Number

[muhammad susanto]

hi all..

would you help me to figure out this problem.
i want use formula to solved it..

<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]after formula[/TH]
[/TR]
</thead><tbody> [TR]
[TD]'1.1
[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]'2.3
[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]'2.2
[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]'4.1
[/TD]
[TD]41[/TD]
[/TR]
</tbody>[/TABLE]


thanks appreciated for your helping

.sst

 

[Marcelo Branco]

Maybe...

=--SUBSTITUTE(A2,".","")

M.

 

[joeu2004]

If your Excel and system configuration recognizes 1.1 [sic] as a number, you can write simply =A1*10.

Otherwise, one of the following formulas should work:

=--SUBSTITUTE(A1,".","")
or
=--TRIM(SUBSTITUTE(SUBSTITUTE(A1,".",""),CHAR(160),""))

The latter is needed only if the text in column might contain spaces or non-breaking spaces.

 

[muhammad susanto]

hi guys...thank you very much!! it was help me..