Vba to convert text format numbers to numbers

[pedie]

Is there a way to convert text format numbers to numbers through Vba?

There is a way to find out but i dont know if we can make it to numbers...

The numbers looks like this 34645 but it is in text

Please advice.

 

[MrKowz]

Format all cells as general, then use:

Public Sub Pedie()
Dim rng As Range
For Each rng In ActiveSheet.UsedRange
    rng.Value = rng.Value
Next rng
End Sub

 

[RLY]

Exactly what I was looking for...
Thanks MrKowz.

 

[pedie]

Thanks MrKowz