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>

data	after formula
'1.1	11
'2.3	23
'2.2	22
'4.1	41

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

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