Format Excel Column Type to Number

[prasath17 (Guru)]

@emounica - Could you please check this post…

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

@AS07 - Here you go… My Input [image] My Output After running the macro… [image] 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 [image]