View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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?