Change Default Auto-Fill-In month

[scootr]

If I format a cell as a date mm/dd/yy; If I only type in the month and date,
"4/15" ,excel will automatically fill in the the current year, so the cell
will end up displaying 4/15/10.

But if I only type in the date, "15", then excel will fill in the January
2000 as the default month and year, so the cell will end up displaying
1/15/00.

Is there a way to tell excel to auto fill in the current month and current
year when I do this? (example: If I type in the date, "15", then I want excel
to fill in today's month and year, so the cell will display 4/15/10.)

 

[ozgrid.com]

Ctrl+; and edit the day.

 

[scootr]

I don't really understand.
Ctrl+

I hold "Ctrl" and the "+" keys and nothing happens.

 

[Dave Peterson]

You could use a macro. But I wouldn't. I'd be worried that a number that I
wanted would be converted to a date.

You could use two cells (or two columns of cells???) with a formula in the
second column that uses the first cell to create the real date.

So if you enter 15 in A1, you could use this in B1:
=date(year(today()),month(today()),a1)
or maybe better:
=if(a1="","",date(year(today()),month(today()),a1))

But you'll have to make sure you enter a valid day for the current month.

 

[David Biddulph]

He said Ctrl+; In other words hold the Ctrl key and use the ; (semi-colon)
key.

 

[scootr]

Thanks for all of your help guys.
I found a simple solution.

I just formatted the cells as TEXT.
Everything appears to be working exactly as I want.

Again,
Thanks for your help.