Microsoft KB Archive/87957

{|
 * width="100%"|

PRJ3: Numbers Not Sorted Correctly

 * }

Q87957

-

The information in this article applies to:


 * Microsoft Project for Macintosh, version 3.0
 * Microsoft Project for Windows, version 3.0

-

SYMPTOMS
When you compare text field values in Microsoft Project, you may not receive the results you expect if the text includes numbers greater than 32,767.

CAUSE
If text fields contain numbers greater than 32767, you receive random results when you compare the fields. This behavior affects sorting and filtering.

Example
If tasks 1-10 have WBS values of 10000, 20000, 30000, ..., 100000, respectively, then sorting by WBS in ascending order produces the following task ordering: 10, 4, 5, 6, 7, 1, 8, 2, 9, 3. The correct sort order is 1, 2, 3, ..., 10.

This problem occurs even if there are alpha characters in the fields as well. The above example produces the same results, for instance, even if the WBS values are aaa10000, aaa20000, ..., aaa100000.

WORKAROUND
If the values in the fields contain only numbers, use a custom number field (Number1-Number5) instead of a text field.

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Project listed above. This problem has been corrected in Microsoft Project version 4.0.

Additional query words: Comparisons Incorrect

Keywords :

Issue type :

Technology :