True Convert to Number-VBA

[catalena2]

I'm trying to convert a selected range to a number. The only way it works when doing it manually is when you click on the flag and select Convert to Number. Multiplying the values by 1, copy and pasting values, and changing the formatting (via right click, format cells, Number) all do not work and a green flag remains in the top left corner of the cells

How can I get do this via VBA?

Code:

Sub Format_Column()

Range("G2").Select​

Range(Selection, Selection.End(xlDown)).Select​

xxxxxx​

End Sub

 

[SQUIDD]

Hi

I believe you could use text to columns in the data TAB?
I think you can use the macro recorder to get what you require.

Dave

 

[JLGWhiz]

Show an example of what in in the range you want to convert. Also clarify if you want to format the range as Integer, or if you have text value that you want to convert to numeric value.

 

[SQUIDD]

or

what happens when you use copy and paste back as values

dave