I have a spreadsheet with multiple numbers stored as text. I wish to convert all of the numbers stored as text to numbers. I wrote this code:
Range("A2").Select
Selection.CurrentRegion.Select
If IsNumeric(xCell) Then
For Each xCell In Selection
xCell.Value = Val(xCell.Value)
Next xCell
End If
My problem is that it converts all of my text to 0's when it converts the numeric text values to numbers.
Thank you!
Range("A2").Select
Selection.CurrentRegion.Select
If IsNumeric(xCell) Then
For Each xCell In Selection
xCell.Value = Val(xCell.Value)
Next xCell
End If
My problem is that it converts all of my text to 0's when it converts the numeric text values to numbers.
Thank you!