ExcelBanter - Sort by date in Excel 2002?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sort by date in Excel 2002? (https://www.excelbanter.com/excel-discussion-misc-queries/28959-sort-date-excel-2002-a.html)

Betty

Sort by date in Excel 2002?

How to sort by year with this format Sept 9/03

Is the data formated to look like that or is it a text entry?
if it is a format. It will sort just using any sorting procedure.
if it is text use a helper column with
=right(A1,2)

"Betty" wrote:

How to sort by year with this format Sept 9/03

All times are GMT +1. The time now is 07:00 PM.