last name May sorted as Month in pivot table

  • Thread starter Thread starter susanne
  • Start date Start date
S

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
 
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
 
Back
Top