I have a pivot table of students taking courses, which I need to sort by
surname. One of the students' surname is May, and Excel always puts this at
the top of the list, before Adams & Anderson etc. It's the same if I change
the source data so that the person's name is April or December.

I've tried formatting it as text, but this doesn't seem to have any effect.

Any ideas gratefully received.