Microsoft KB Archive/68845

{|
 * width="100%"|

Sorting by Numbers in a Text Field Appears Incorrect

 * }

Q68845

-

The information in this article applies to:


 * Microsoft Project for Windows, version 1.0
 * Microsoft Project for the Macintosh, version 1.1

-

SUMMARY
When sorting tasks by a text field in Project for Windows and Macintosh, the tasks may appear to sort incorrectly if the fields contain only numbers.

MORE INFORMATION
If you enter numeric values in one of the six text fields in a project task (TEXT1-TEXT6), Project interprets these values as text strings and not as numbers. If you then sort on one of these fields, the results may not be what you expect.

For example, if you have entered values of 1020 and 30 in the TEXT1 field of two different tasks, and you sort using the TEXT1 field in ascending order, the task containing 1020 will come before the task containing the 30. This is because using standard rules for an alphabetical sort, a text value of 1020 is less than a text value of 30.

If you want your sort to accurately reflect the numerical value of the field, you must enter leading zeros for all your numbers. In the above example, entering 0030 and 1020 will result in a sort consistent with the numbers entered.

Additional query words: 1.00 1.10

Keywords :

Issue type : kbinfo

Technology :