Excel sort application should work with Project WBS

R

Ribas

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/com...dg=microsoft.public.excel.worksheet.functions
 
J

Jim Cone

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


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.
 
Top