Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I am trying to sort a column of numbers in numerical order. When I attempt to do this excel seems to want to sort them as though they were letters. Here is an example: 1* 10032* 10044* 10071* 10107* 10175* 102164* 10306* 10353* 10394* 10421* 1044* 1045* 10471* 10670* 10683* 10730* 10759* 10769* 10795* 1081* 10853* 10875* 10877* 110800* 11137* 11246* 113366* 11385* 1142* 11480* 11524* 11563* 1165* 117* 12062* I have checked that it is formatted as a number and not text. I have no idea how to make excel sort them in numerical order. Any thoughts? Cheers, D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort 2 column in the same time "" as dictionary "" | Excel Worksheet Functions | |||
Sort "text" numbers with and without leading zeros as numbers | Excel Discussion (Misc queries) | |||
My Column display as "numbers" instead of "alphabets" | Excel Discussion (Misc queries) | |||
Can Excel "extract" ranges of numbers listed in the A column? | Excel Programming | |||
Can Excel "extract" ranges of numbers listed in the A column? | Excel Discussion (Misc queries) |