last name May sorted as Month in pivot table

[susanne]

I am importing data into an excel 2002 spreadsheet. The
data has a field called Last Name that is formatted as
text.

In a pivot table the last name of May shows up first. I
have verified that excel thinks it is a date. I have
unclicked auto formatting and clicked preserve formatting
among other things. This field keeps reverting to general
formatting.

Any advise?

Thanks in advance
susanne

 

[Debra Dalgleish]

In your source data, you can replace the name May with May<space>, and
it should sort properly.

To change the names, select the column, and choose Edit>Replace
In the Find what box, type: May
In the Replace with box, type: May and press the spacebar
Click the Replace All button
Confirm the replacement, and click Close