text to number

[amrane]

Dear Forum,

I am not founding in vba code to change cells contain form text to number!!

how to do it!!

currently, its EXCEL with comma as decimal point

br, amrane

[ranman256]

set the column where you want. Also, instead of VAL ,you can use CDBL




Sub Cvt2Num()

range("A2").select
While ActiveCell.Value <> ""
ActiveCell.Value = val(ActiveCell.Value)
ActiveCell.Offset(1, 0).Select 'next row
Wend
End Sub

[Bob Phillips]

Sub ReplaceCommas()
Columns("A:A").Replace What:=",", _
Replacement:=".", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False, _
SearchFormat:=False, _
ReplaceFormat:=False
End Sub

[amrane]

Dear Mr ranman256, Mr xld
Thx a lot for your quick suport,

br amrane