Convert text to values

[John M]

Hello,

I just downloaded a large amount of numbers from the
internet, but unfortunately they came over to my Excel
spreadsheet in text format. I need to perform
calculations with this data. Is there a fast way to
convert all the data to numerical values?

Thanks, John

 

[Gerrit]

Hello,

I just downloaded a large amount of numbers from the
internet, but unfortunately they came over to my Excel
spreadsheet in text format. I need to perform
calculations with this data. Is there a fast way to
convert all the data to numerical values?

Thanks, John

Sub fTwo()
With ActiveSheet.UsedRange
.Value = .Value
End With

End Sub

its the same as F2 in each cell

 

[Alan]

Another way,
Enter 1 in an vacant cell, right click > Copy
Highlight all your numbers, right click, Paste Special > check Multiply > OK
Delete the 1 in the vacant cell,
Regards,