Actually, update on that, because I found the workaround, but it's far from
obvious. I had looked at the date settings, and the short form was
"03-Dec-2008" and the long form was "Wednesday, December 03, 2008". both
looked fine, and the preferences were set to US/English, so what's not to
like, right? You'd think with the US/English setting that entering 12/3/08
would give you December 3rd instead of March 12th, right?
Well, you might think so, but you'd be wrong. If you like to display OR
ENTER dates as mm/dd/yy, apparently you need to change the short date format
to "m/d/yy" (which you do by clicking the Customize button under Regional
Options and then selecting the short date format on the Date tab) --
otherwise, it will always interpret that first digit as the day rather than
the month. My contention is that a)this IS a bug and b)it WAS introduced
recently, but whatever, I found my workaround and so I'm ok with it. I hope
others who got bit likewise can find this answer.
lbb said:
My regional settings are correct -- sorry, I should have stated that.
T. Valko said:
Excel interprets dates based on the regional date settings of your operating
system. Check your systems regional date settings.
As far as updates, you should install updates.....just don't do it
immediately after they're released. I wait a few weeks. This way, if an
update is released with a major bug others will discover [read:
"experience"] it and report it. Then they *might* re-release the update
bug-free.
--
Biff
Microsoft Excel MVP
lbb said:
When I enter November 1, 2008 as 11/1/08, it is interpreted as January 11,
2008. This started happening recently, probably after I unwisely
downloaded
the latest MS updates (I'll never do that again). What's the deal? My
preferences are all for US, so what's the problem?
