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

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


(for formulas, depending on your country, you might have to change ; with , or the opposite

Other excel answers



You can find similar Excel Questions and Answer hereunder

1) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

2) How to debug a macro in Excel VBA

3) How can I clear cell after activating a routine when there is a change in value of a cell?

4) How can I execute an event at a predetermined time from my Macro?

5) Vba delete entire row if contains certain text in Excel

6) How can I add a Timestamp after macro execution?

7) I have a macro that takes a lot of time for execution - how can I keep the user informed that the macro is running?

8) How can I enter a text in a cell with subscript and superscript?

9) Vba to return week numbers in Excel

10) How can I prevent users from seeing / accessing my macro code?


Here the previous and next chapter