【excel宏】excel解决数据非数字类型办法

创建如下宏，解决数据非数字类型的烦恼

Sub macro()

    Range("F:F").Select 'specify the range which suits your purpose

    With Selection

     Selection.NumberFormat = "General"

     .Value = .Value

    End With

End Sub