VBA help to Convert tex number of diffrent solumn to number

[Mallesh23]

Hi Team, 

I am trying to convert the the number which are in text to number
Numbers in few column(C:C and I:I) getting deleted.

below are two method getting same result, 

plz suggest any best method to tackle this task.

Sub Convert_TextNumber_Number()


Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets("Sheet1")

ws.Range("A:A,C:C,F:F,I:I,L:L").Select
Range("A1,C1,F1,I1,L1").EntireColumn.Select

With Selection
.NumberFormat = "General"
.Value = .Value

End With

End Sub

 

[Mallesh23]

Hello Sir,

Your approach has worked successfully, getting error at pikes approach, I have header and those are getting filled down for column C and I,
have to check with row -2 to lastrow approach. Thanks both of you great Job !

Regards,
Mallesh

 

[Peter_SSs]

Hello Sir,

Your approach has worked successfully,...

You are welcome.