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 |
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. |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com