In a date formatted field, when I type in the month and day and tab, the
current year (2010) is entered. Is there a way to cause a different year
(2009) to be entered instead?

Not with autocomplete.

Regards,
Fred

"Vance" wrote in message
...
In a date formatted field, when I type in the month and day and tab, the
current year (2010) is entered. Is there a way to cause a different year
(2009) to be entered instead?

Excel will use the year of the system date.

So you could cheat and change the computer's date to the year you want.

Remember to change it back when you're done.

Vance wrote:

In a date formatted field, when I type in the month and day and tab, the
current year (2010) is entered. Is there a way to cause a different year
(2009) to be entered instead?

--

Dave Peterson

You could use a formula in a helper row/column:
=DATE(2009,MONTH(A2),DAY(A2))

or (use w/ caution) temporarily change your system date to a 2009 date.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Vance" wrote:

In a date formatted field, when I type in the month and day and tab, the
current year (2010) is entered. Is there a way to cause a different year
(2009) to be entered instead?