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.
Answer
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
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?