Change Default Auto-Fill-In month

S

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

scootr

I don't really understand.
Ctrl+

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

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

David Biddulph

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top