Change Default Auto-Fill-In month

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.)

Ctrl+; and edit the day.



--
Regards
Dave Hawley
www.ozgrid.com
"scootr" wrote in message
...
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.)

I don't really understand.
Ctrl+

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

"ozgrid.com" wrote:

Ctrl+; and edit the day.



--
Regards
Dave Hawley
www.ozgrid.com
"scootr" wrote in message
...
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.)

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.

scootr wrote:

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.)

--

Dave Peterson

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


"scootr" wrote in message
...
I don't really understand.
Ctrl+

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

"ozgrid.com" wrote:

Ctrl+; and edit the day.



--
Regards
Dave Hawley
www.ozgrid.com
"scootr" wrote in message
...
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.)

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.

"Dave Peterson" wrote:

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.

scootr wrote:

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.)

--

Dave Peterson
.