|Subject:||Unwanted Number Sorting Order|
|Date:||Thu, 2 Aug 2007|
I was baffled by the results Excel spitted out for me today. I was sorting
numbers and Excel seems to be sorting it by its first digit then second and
so forth. I checked that all the numbers are under "General" format and
there was nothing special I have done to alter Excel's sorting settings.
An example of what I am talking about:
Say I want to sort the following numbers: "1,2,100,200"
Excel would spit out "1,100,2,200" for me and I really don't want that.
Is there anything I can do to make it sort according to normal numerical