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.
>