Convert text into numbers

Hi all,

I've recorded a small macro that basically just formats an Excel-sheet into a format that I like to work with. The "raw" data is retrieved from a database. In this case Excel treats some data as text when it is actually numbers and I need to correct that. It is very easy to do manually but I would like my macro to do it for me. For some reason it's not possible to record this action and I can't seem to find a code snippet or other explanation that works for this particular issue.

Any help on this would be greatly appreciated. I have attached an example.