View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
livetohike livetohike is offline
external usenet poster
 
Posts: 10
Default Default entry to year other than current

I need to enter a whole bunch of dates in 2006.

Currently I have to type 2/23/06, 5/12/06, etc.

I would like to type 3/23, 5/12, etc. and have it default to 2006
(rather than the current year).

This would save a lot of typing.

Can do?
Thanks