Change Default Auto-Fill-In month
in [General]
|
Prev: Filter with criteria!
Next: Unpivoting a worksheet
From: scootr on 15 Apr 2010 03:46 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.)
From: ozgrid.com on 15 Apr 2010 04:38 Ctrl+; and edit the day. -- Regards Dave Hawley www.ozgrid.com "scootr" <scootr(a)discussions.microsoft.com> wrote in message news:494E3036-EEE2-4D8E-B6E6-3E1266A19457(a)microsoft.com... > 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.)
From: scootr on 15 Apr 2010 06:47 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" <scootr(a)discussions.microsoft.com> wrote in message > news:494E3036-EEE2-4D8E-B6E6-3E1266A19457(a)microsoft.com... > > 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.) >
From: Dave Peterson on 15 Apr 2010 07:50 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
From: "David Biddulph" groups [at] on 15 Apr 2010 15:53
He said Ctrl+; In other words hold the Ctrl key and use the ; (semi-colon) key. -- David Biddulph "scootr" <scootr(a)discussions.microsoft.com> wrote in message news:08B2457D-BDCE-4AF7-87E5-93719001BB59(a)microsoft.com... > 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" <scootr(a)discussions.microsoft.com> wrote in message >> news:494E3036-EEE2-4D8E-B6E6-3E1266A19457(a)microsoft.com... >> > 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.) >> |