 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2007When typing dates do not default to current year.
I used to (with my old computer) be able to type in "Jul 5" as an example, and have Excel populate the cell with the current year "Jul 1, 07" ie. fill the year. With my new computer, it fills this input as "Jul 1, 01" Any ideas on how I can get the current year to populate automatically? When you say Jul 1, Excel assumed that you meant Jul 2001 (and if you put in a month and a year, Excel defaults to the first of the month). I think you'll find that if you type in 1 Jul, rather than Jul 1, it will take it as 1st July in the current year. If there is a difference between your new and old computers, I might wonder whether there is a difference in Windows regional settings, but I haven't experimented to see what settings (if any) might have given the behaviour you saw previously.  SignatureDavid Biddulph >I used to (with my old computer) be able to type in "Jul 5" as an example, > and have Excel populate the cell with the current year "Jul 1, 07" ie. > fill > the year. With my new computer, it fills this input as "Jul 1, 01" Any > ideas on how I can get the current year to populate automatically? Thanks for the help. Your solution does work. What I find odd, is with my old computer, and with others in our office, you can autofill the current year when you type "Jun 30" or any other month and date. The year did on my old computer, and others in our office would complete this as 30-Jun-07 or what ever format you had your dates set up. > When you say Jul 1, Excel assumed that you meant Jul 2001 (and if you put in > a month and a year, Excel defaults to the first of the month). [quoted text clipped - 10 lines] > > the year. With my new computer, it fills this input as "Jul 1, 01" Any > > ideas on how I can get the current year to populate automatically? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.