format number

[sal21]

in the cloumn C2:C2500 in text format, i have this value

282215,82
8525,73
68574,93
10652,78
2722,29
4075,71
21283,73
....

this number is imported fronm a text file, from this line

var_CAUS = Trim(Mid(riga, 65, 14))

my prob is to insert a "." and trnsform in

282.215,82
8.525,73
68.574,93
10.652,78
2.722,29
4.075,71
21.283,73

automaticly whe the macro import the data string.

 

[bjwillingham]

Try

var_CAUS = val(Trim(Mid(riga, 65, 14)) )

That will put a value in your cells. If your cells are formatted at "#.##,##" you should see what you want.

 

[jimboy]

This works for me;

Sub Macro3()
'
    With Range("C2:C500")
    
    .NumberFormat = "#,##0.00"
    .Replace What:=",", Replacement:="."
    End With
End Sub