Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why 8-Mar-08?
Sat, 22 Mar 2008 05:23:01 -0700 from Eric
: 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why 8-Mar-08?
If you just want to "show" the month, change the format and just type in
3/1 -- Don Guillett Microsoft MVP Excel SalesAid Software "Eric" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why 8-Mar-08?
Try entering Mar-2008.
HTH, Barb Reinhardt "Eric" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why 8-Mar-08?
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 "Barb Reinhardt" wrote: Try entering Mar-2008. HTH, Barb Reinhardt "Eric" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why 8-Mar-08?
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. -- David Biddulph "Eric" wrote in message ... 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 "Barb Reinhardt" wrote: Try entering Mar-2008. HTH, Barb Reinhardt "Eric" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why 8-Mar-08?
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 "Stan Brown" wrote: Sat, 22 Mar 2008 05:23:01 -0700 from Eric : 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why 8-Mar-08?
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. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Eric" wrote in message ... 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 "Barb Reinhardt" wrote: Try entering Mar-2008. HTH, Barb Reinhardt "Eric" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|