Regional Settings don't affect Excel 2000??

[Samson]

Hi all


It's been quite a while since I've posted here! Cripes!

Hope all are well

Anyway -- Bit of a truffle here, I've got UK Language & KB settings, and UK regional settings set on all our 2K machines, UK dates, the whole caboodle -- However for some reason, Excel 2000 doesn't seem to take them. It still formats Date in MM/DD/YYYY instead of DD/MM/YYYY.

It's frustrating for me because I've spent all this time setting the machines up for UK settings, then the teacher comes straight back to me saying it still doesn't work.

Any suggestions anyone?

Thanks

[User3204]

Excel 2000... And I get hassled for not going to 2007..

Anyway... When you installed Excel, did you have the right region settings or did you change this afterwards ?

I also remember vaguely, that you could choose locale settings for office on it's install, if you did the "advanced" / "custom" / or whatever install.

I'm going to assume you've checked in all three places in Windows 2000, that you've set the defaults to EN-UK as opposed to EN-US.

[Samson]

As far as I know, if memory serves, the regional settings were set to UK on office install... however I may be wrong.

Regardless, is there a GPO I can push out or some setting I may be missing that can remedy this?

Even when Windows itself is set to EN-UK, Excel still defaults to american dates etc.

[elsiegee40]

From what i remember of this one... I had it many moons at my last school... Office 2000 doesn't pick up its region settings from the PC, they get it from the Microsoft Office Language Settings which is on the start menu somewhere. It's easy ti miss on install and a pain in the proverbial.

I ended up doing it manually on each PC - about 40 of them