Hi,

I have bunch of "numbers" in column 1 like

2
9
15
71
8

but when I sort, the 9 is at the bottom of the list because it is not truly
numeric.

From what I've read in this forun, I was able to identify the cells that are
not numeric by using:

Sub test()
Dim rng As Range

Set rng = ActiveSheet.Columns(1).SpecialCells(xlConstants, xlTextValues)
rng.Select
End Sub

Now that I am able to identify the locations of the cells, is there a quick
way to change them to numeric values?

Thanks!