Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() That is the way Excel sorts...character by character ( 1 comes before 9). or maybe... http://www.officeletter.com/blink/specialsort.html review of a commercial program Jim Cone San Francisco, USA "Ribas" wrote in message I saved a MS Project as a MS Excel file. One of the fields that where in the file was the WBS (1.1, 1.1.2, .1.4.5). When in the excel sheet I try to sort by this column, it separates not just each number between the dots, but each digit. Example: the number 1.1.14 comes before 1.1.9, and that should not happen. Hope Ill get an answer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XLSSTART\ does not works when Excel is launched from other application | Excel Discussion (Misc queries) | |||
I want to sort selected cells in Excel, not entire rows. | Excel Discussion (Misc queries) | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) |