Convert text to values

  • Thread starter Thread starter John M
  • Start date Start date
J

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
 
John M said:
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
Click to expand...

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

End Sub

its the same as F2 in each cell
 
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,
 
Back
Top