Sort "mm-dd-yyyy" by year
 

Obviously, since the month is the first number the sort feature sorts by
that. Is there a way to sort by the year instead - or do I need to add
another column that just shows the year and sort by that first?

Sort "mm-dd-yyyy" by year
 

"Munchkin" wrote in message
...
Obviously, since the month is the first number the sort feature sorts by
that. Is there a way to sort by the year instead - or do I need to add
another column that just shows the year and sort by that first?

Sort "mm-dd-yyyy" by year
 

Your assumption is incorrect.
What is shown is not what the value of the cell is.
Just try.

To know all about dates, look he

http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Munchkin" wrote in message
...
Obviously, since the month is the first number the sort feature sorts by
that. Is there a way to sort by the year instead - or do I need to add
another column that just shows the year and sort by that first?

Sort "mm-dd-yyyy" by year
 

<What is shown is not what the value of the cell is.

Unless you entered the dates as text

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message
...
Your assumption is incorrect.
What is shown is not what the value of the cell is.
Just try.

To know all about dates, look he

http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Munchkin" wrote in message
...
Obviously, since the month is the first number the sort feature sorts by
that. Is there a way to sort by the year instead - or do I need to add
another column that just shows the year and sort by that first?