| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i change the default date to 2006?
Type 9 Apr or 9 April and format cell (Custom) as mmm-dd-yy
"Alex" wrote: Hi, when I try to type in a date, it keeps coming up a totally different date, for example, when I try to type in a date, it only comes up with the first of every month, and the year 2002. What I want it to do is, when I type in "april 9" it will automatically populate" apr-9-06" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change date default | Excel Discussion (Misc queries) | |||
| What's difference in writing date as 18/10/2006 and '18/10/2006 | Excel Discussion (Misc queries) | |||
| What's difference in writing date as 18/10/2006 and '18/10/2006 in | Excel Discussion (Misc queries) | |||
| How do I change the date in the 2005 attendance calendar to 2006 . | Excel Discussion (Misc queries) | |||
| How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
