Type the year, too.

If you don't type the year, then excel figures you want the current year.

Canwoman88 wrote:

When I type a registration date in a database, such as Nov-05, and press
enter, the year automatically updates to 06. How can I stop the update?

--

Dave Peterson