Ascending Order

Hi, I hav a number of data from 1 to 150....when i try sort it in ascending order, the number become 1>10>11>100...but not 1>2>3>4 like that..any way to correct it?

Hi, most probably, you work with numbers, stored as text. That's why it sorts them like this.