Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Fill days of the month (not including weekends) | Excel Worksheet Functions | |||
Change default fill color | Excel Discussion (Misc queries) | |||
Formula to auto fill in following month. | Excel Worksheet Functions | |||
excel auto fill needs to be have default action (series,copy...) . | Excel Discussion (Misc queries) | |||
Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) |