Thread: Arranging Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default Arranging Dates

I have a group of dates I want arranged chronologically. When I sort on the
column that contains the dates, the application seems to think that 5/27/2007
comes before 6/1/2006. It seems to be keying on the month instead of the
year. How do I need to format the cells in order that the application takes
into account the whole date, not just the month and day?
--
Kevin