 |
 | 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 / General Excel Questions / March 2008Why 8-Mar-08?
Does anyone have any suggestions on date? When I type Mar-08 into any cell, the default day is 8-Mar-08. Does anyone know why the default day is 8? and how can I change the default day into 1? Does anyone have any suggestion? Thanks in advance for any suggestions Eric Sat, 22 Mar 2008 05:23:01 -0700 from Eric <Eric@discussions.microsoft.com>: > Does anyone have any suggestions on date? > When I type Mar-08 into any cell, the default day is 8-Mar-08. > Does anyone know why the default day is 8? and how can I change the default > day into 1? I think you have your date format set to d-m-y. When you type Mar-08 Excel says "that looks like a date, in fact it looks like the 8th day of March. But I'm supposed to display d-m-y, and the current year is 2008", so it displays 8-Mar-08. In other words, it's the default year of 2008 that you're seeing, not a default day. Try entering Mar-09 and you'll see it changes to 9-Mar-08 not 8-Mar- 09.  SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... Yes, I have checked the date format under control panel , which is M/D/Y, when I change it to D/M/Y and re-load the web link, it becomes 1-Mar-2008. Thank everyone very much for suggestions Eric > Sat, 22 Mar 2008 05:23:01 -0700 from Eric > <Eric@discussions.microsoft.com>: [quoted text clipped - 13 lines] > Try entering Mar-09 and you'll see it changes to 9-Mar-08 not 8-Mar- > 09. If you just want to "show" the month, change the format and just type in 3/1 SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Does anyone have any suggestions on date? > When I type Mar-08 into any cell, the default day is 8-Mar-08. [quoted text clipped - 4 lines] > Thanks in advance for any suggestions > Eric Try entering Mar-2008. HTH, Barb Reinhardt > Does anyone have any suggestions on date? > When I type Mar-08 into any cell, the default day is 8-Mar-08. [quoted text clipped - 3 lines] > Thanks in advance for any suggestions > Eric Thank everyone for suggestions The text "Mar-08" is imported by web link, therefore, there is nothing I can change for the input. Do you know why the default day is 8? Thank everyone for any suggestions Eric > Try entering Mar-2008. > [quoted text clipped - 8 lines] > > Thanks in advance for any suggestions > > Eric Pl;ease read again what you've been told (in Stan's reply). The default day is *not* 8. The default *year* is the current year. When you said Mar-08 it assumed you wanted March 8th, and added this year, 2008. SignatureDavid Biddulph > Thank everyone for suggestions > The text "Mar-08" is imported by web link, therefore, there is nothing I [quoted text clipped - 16 lines] >> > Thanks in advance for any suggestions >> > Eric The default day is not "08". When you enter "Mar 08", Excel assumes you mean March 8th of the current year, and that current year is 2008, which is can be displayed as "08". The format applied to a cell has *no* effect on how Excel interprets dates when they are entered. Formatting affects *only* the displayed text. There is no such date as "March 2008". You need to enter then entire date, March 1, 2008. SignatureCordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) > Thank everyone for suggestions > The text "Mar-08" is imported by web link, therefore, there is nothing I [quoted text clipped - 16 lines] >> > Thanks in advance for any suggestions >> > Eric |
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.