How Convert Excel Column From Text To Number Format

[Teaf]

i tried the below but unfortunately not work .

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]