Excel Pivot Tables not sorting the word SUN properly

When creating a pivot table based on an Excel list, the word SUN is not
sorted properly when using the pivot table advanced sort options.

Leading space perhaps?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"natheem" <[email protected]> wrote in message
news:[email protected]...
> When creating a pivot table based on an Excel list, the word SUN is not
> sorted properly when using the pivot table advanced sort options.
>

SUN goes to the top of the list because Excel assumes it means Sunday,
and it appears in one of the built-in custom lists.

When you create a pivot table, and Excel detects an entry from a custom
list, it uses that list as the sort order. So, in your table, SUN sorts
to the top, and the other items appear below, because they're not in the
Weekdays custom list.

If you manually sort the list, SUN should move to the correct position
alphabetically. Or, perhaps you could add a space at the end of SUN in
the source table.

natheem wrote:
> When creating a pivot table based on an Excel list, the word SUN is not
> sorted properly when using the pivot table advanced sort options.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html