converting numbers stored as text to numbers...

Just to added to carim's post

Sub Macro()
With Selection
Selection.NumberFormat = "General" 'Change from text format
.Value = .Value
End With
End Sub

VBA Noob