Hi,

I am attempting to sort a list of companies that are formatted in our
database system by month/date/year (mm/dd/yyyy). I want them to sort by
month and date only, however Excel 2000 recognizes the year as a criteria.

How do I get the program to ignore the year information for these 4,000+
entries?

Thanks so much.
SMW820