It should sort it in numerical order.

Which version of excel are you using?

Look at some of the options on the sort or is there spaces or text in there?
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Jason Zischke" wrote:

Hi All,

I was wondering if there is a way to get excel to sort numerically as below
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11
rather than
1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9

Thanks in Advance

Jason