sorting numbers

Al J

New member
Joined
Dec 16, 2013
Messages
2
Reaction score
0
Points
0
805
Bear
Pascoe
NYG
13
9
16
62
4.8
6.9
14
4.8
2
0
0
0
0.0
N/A
0
0
0
789
Vance
McDonald
13
8
17
119
9.2
14.9
25
6.0
5
0
0
0
0.0
N/A
0
0
0
756
Jimmy
Graham
NOR
13
74
117
1046
80.5
14.1
56
5.1
53
14
0
0
0.0
N/A
0
0
0
I have imported this and a lot of other similar data from a website. I would like to sort it in numerical order. Excel will only sort the data in a 1,10,100, 2 type of format. I know from previous experience with older versions I was able to convert this imported data so that it would sort the way I would like it to. But I have forgotten how to do that or whether it can be done in the 2013 version of excel
 

Al J

New member
Joined
Dec 16, 2013
Messages
2
Reaction score
0
Points
0
I figured it out. "CntrlH; alt 0160" was what I was trying to remember. It works.
 
Top