Thread: default year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mic Mic is offline
external usenet poster
 
Posts: 17
Default default year

I have a list of dates (mm/dd) in a column. I have formated the cells to
display mm/dd and this works, however, if you double click on the date it
displays the year. I added most of these different dates in 2007 and I am
now entering more. When I sort them by date, the ones I recently entered
(2008) are at the bottom when what I want is them mixed in with the others.
How do I get it to NOT acknowlegde the year?