View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Default entry to year other than current

Change the computer date back a year and have at it.

livetohike wrote:
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