Proper Conversion to numbers

Hi

So I record a macro but it see only following bit

Range("A2").Select
Range(Selection, Selection.End(xlDown)).Select


I want this selection to be converted to numbers but in proper way (There is a green thing in corner in every cell and on top of column a yellow field with exclamation mark. When whole column is selected and you apply appropirate convert function from this exclamation mark menu it will convert it properly.

While if you just click on excel tab and choose numbers it just does not change it to numbers actually hance it is not a solution please mind that.

Thank You