 |
 | 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 / New Users / June 2007Date Format
Every time I type in the date it uses it for the year. I have my cells formatted for US 10-Nov-2007 but if I type Nov 10 it puts 1-Nov-2010 and if I type Nov 20 it puts 1-Nov-2020 Any ideas how to get a simple Nov 10 to insert Nov 10-2007 Hi, Are you in the US and is your country setting US? On my machine typing Nov 10 works to enter 10-Nov and if I then format it to your format it is correct. Try typing 11/10. or 11-10 Nov-10 Sincerely, Shane Devenshire Excel MVP > Every time I type in the date it uses it for the year. I have my cells > formatted for US 10-Nov-2007 but if I type Nov 10 it puts 1-Nov-2010 and > if I type Nov 20 it puts 1-Nov-2020 > > Any ideas how to get a simple Nov 10 to insert Nov 10-2007 >Every time I type in the date it uses it for the year. I have my cells >formatted for US 10-Nov-2007 but if I type Nov 10 it puts 1-Nov-2010 and if >I type Nov 20 it puts 1-Nov-2020 > >Any ideas how to get a simple Nov 10 to insert Nov 10-2007 Excel interprets the date input based on the short date format in Windows Regional Settings (under Control Panel) -- not based on how you format the Excel cell. You will either need to change that format, or make an unambiguous entry that includes the year. --ron Even though I live in Canada when I changed it from English Canada to English US it works correctly. Didn't realize the Canadian format is so screwy. Thanks. > On Wed, 06 Jun 2007 22:48:56 GMT, "Martin Knight" > <martinknight@hotmail.com> [quoted text clipped - 16 lines] > > --ron >Even though I live in Canada when I changed it from English Canada to >English US it works correctly. Didn't realize the Canadian format is so >screwy. Thanks. You're welcome. Glad to help. Most of the world would claim it is the US format that is screwy, though! :-)) --ron |
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.