View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Default entry to year other than current

One way would be to allow it to default to this year, then subtract 365 from
them all using Paste Special/ Subtract.
--
David Biddulph

"livetohike" wrote in message
ups.com...
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