How to easily convert data to number

[ExcelPupper]

Hi. I have here a sample set of data exported from a MS Access database. My current problem is that it takes time to convert these data to numbers because normally it contains thousands of row. I just want to ask if there's an easier way aside from clicking the yellow sign then click convert to number? Many thanks

 

[Michael M]

Highlight the column , then run this macro

Sub MM1()
Dim c As Range
For Each c In Selection
c.Value = c.Value * 1
Next c
End Sub

 

[Fluff]

You can select all the data from B2 down & then click the ! mark to convert the entire data, or you can use text to columns.