If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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.) |
#2
|
|||
|
|||
Change Default Auto-Fill-In month
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.) |
#3
|
|||
|
|||
Change Default Auto-Fill-In month
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.) |
#4
|
|||
|
|||
Change Default Auto-Fill-In month
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 |
#5
|
|||
|
|||
Change Default Auto-Fill-In month
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.) |
#6
|
|||
|
|||
Change Default Auto-Fill-In month
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 . |
Thread Tools | |
Display Modes | |
|
|