Unwanted Number Sorting Order

Giganews Newsgroups
Subject: Unwanted Number Sorting Order
Posted by:  Erica
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
orders again?