Convert cell or range value from text to number [Excel][Vb]

[prasath17 (Guru)]

@AS07 - Here you go…

My Input

My Output After running the macro…

VBA macro i used…(Write it in a notepad and saveas .vbsfile…)

My workflow

Sub macro()
Range(“C:C”).Select 'specify the range which suits your purpose
With Selection
Selection.NumberFormat = “General”
.Value = .Value
End With
End Sub