How do you apply the int() in VBA in order to convert numbers stored as text to numbers

Greetings,

Stumbling on something probably easy for you all...
I have a column of data I pull into a spreadsheet, then reference the cell with a VLOOKUP. Problem is; when I dump the data it overrides the formatting I have set up in that column and still stores it as text. I've also tried recording a macro to select the cells, then "Convert to Number" but the macro will NOT record that function.

I would like to build converting the data into a number, into the code. Not sure how to do that though? Am I on the right track with the following - I didn't put it in as code because it's not a valid code...

Range("B11:B10000").Select
Selection.NumberFormat = "int()"

Thanks in advance!

Try this...

Please Login or Register  to view this content.