Thread: default year
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default default year

To be a date, you need to include the month, day and year.

You could enter info that isn't a real date by either:
Preformatting the cell as Text, then type the mm/dd
or
start your entry with an apostrophe: 'mm/dd

Or if you already have the dates and don't care about the year, you could select
the range and change all the 2007's to 2008 (via edit|replace).

Or if you want the data to retain the year, you could use a helper column that
contains a formula that ignores the year:

=text(a2,"mm/dd")
drag down
and sort by this column.

Mic wrote:

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?


--

Dave Peterson