View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erica Erica is offline
external usenet poster
 
Posts: 22
Default Unwanted Number Sorting Order

Hello,

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?