Converting numbers stored as text to numbers via macro in Excel
I'm looking for the VBA command for this function. I tried just recording a macro in where I perform the task but it didn't record anything. Tried it several times even.
This is a nice demonstration how to do it. Follow the link for more details
Range("F:F").Select 'specify the range which suits your purpose
Selection.NumberFormat = "General"
.Value = .Value
(for formulas, depending on your country, you might have to change ; with , or the opposite