VBA Macro to convert text to number

Hi,

I currently have a set of data that is "stored as text" in a number of cells. As a result, my vlookup formula is not reading the numbers since they are text and not numbers.

Rather than manually clicking each number and pressing "convert to number"... Could someone help me with a VBA macro that automatically converts all the items in a specific column to number so that the Vlookup formula works?


I've attached an excel sheet with this message as an example.

Thanks for all your help!!!!