PRJ: How Microsoft Project Sorts Text Fields (124032)
The information in this article applies to:
- Microsoft Project 2000
- Microsoft Project 98 for Windows
- Microsoft Project for Windows 95 4.1
- Microsoft Project for Windows 95 4.1a
- Microsoft Project for Windows 3.0
- Microsoft Project for Windows 3.0a
- Microsoft Project for Windows 4.0
- Microsoft Project for the Macintosh 3.0
This article was previously published under Q124032 SUMMARY
Microsoft Project uses the "smart-sort" technique to sort data in text
fields. This type of sort is not strictly an alphabetical one. If a string
contains numbers, Microsoft Project treats those numbers as numeric values
instead of treating them as their string equivalents.
MORE INFORMATIONExample (Ascending Sort Order)
String1: G35L
String2: G325L
When these values are sorted in Microsoft Project, string1 is above string2. In an alphabetical sort, string2 would be ordered above string1.
Microsoft Project starts an alphanumeric comparison by comparing the "G" of
string1 to the "G" of string2. Because the next characters are numbers,
Microsoft Project treats them as numeric values, and compares the number 35
to the number 325. The number 35 is less than the number 325, therefore
Microsoft Project sorts string1 above string2.
| Modification Type: | Major | Last Reviewed: | 8/15/2006 |
|---|
| Keywords: | kbhowto kbusage KB124032 |
|---|
|