Date Sorting in Excel 2003

  • Thread starter Thread starter Ruth k.
  • Start date Start date
R

Ruth k.

I need to be able to sort by dates of hire. Excel 2003 sorts everything by
year and I need to sort by month then date and finally year.
 
You could use a helper column with a formula in it:

=text(a2,"mm/dd/yyyy")

It'll look like a date, but it's really a string. But since it's a string, you
can sort it alphabetically.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove date format? 3
Sorting a date by month, date and then year. 2
Sort Dates 11
Am I able to sort dates by month rather than year in excel? 1
Sorting Tables in Excel 2003? 1
Sort dates Excel 2007 1
Date sorting in Excel 2007 2
Sorting date fields by month excluding year 1

Back
Top