ExcelBanter - how do i change the default date to 2006?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do i change the default date to 2006? (https://www.excelbanter.com/excel-programming/357140-re-how-do-i-change-default-date-2006-a.html)

Toppers

how do i change the default date to 2006?

Type 9 Apr or 9 April and format cell (Custom) as mmm-dd-yy

"Alex" wrote:

Hi, when I try to type in a date, it keeps coming up a totally different
date, for example, when I try to type in a date, it only comes up with the
first of every month, and the year 2002. What I want it to do is, when I
type in "april 9" it will automatically populate" apr-9-06"

All times are GMT +1. The time now is 05:11 PM.