Date Sorting in Excel 2003

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.
 
D

Dave Peterson

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

Sorting a date by month, date and then year. 2
Separating dates from one column to Month, Date, Year columns 2
Sorting date fields by month excluding year 1
Remove date format? 3
Sort "mm-dd-yyyy" by year 3
Sorting Dates in format "01/19/09" 8
Sorting In Excel 2
Problem sorting by date after 2029 on Excel 2003 1

Top