Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel sort application should work with Project WBS
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. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel sort application should work with Project WBS
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |