sort issue: Excel seems to be treating my column of numbers"alphabetically"
Hi All,
I am trying to sort a column of numbers in numerical order. When I
attempt to do this excel seems to want to sort them as though they
were letters. Here is an example:
1*
10032*
10044*
10071*
10107*
10175*
102164*
10306*
10353*
10394*
10421*
1044*
1045*
10471*
10670*
10683*
10730*
10759*
10769*
10795*
1081*
10853*
10875*
10877*
110800*
11137*
11246*
113366*
11385*
1142*
11480*
11524*
11563*
1165*
117*
12062*
I have checked that it is formatted as a number and not text. I have
no idea how to make excel sort them in numerical order.
Any thoughts?
Cheers,
D
|