+ Post New Thread
Results 1 to 4 of 4
Windows Thread, Regional Settings don't affect Excel 2000?? in Technical; Hi all It's been quite a while since I've posted here! Cripes! Hope all are well Anyway -- Bit of ...
  1. #1
    Samson's Avatar
    Join Date
    Mar 2007
    Location
    Wales
    Posts
    201
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    16

    Regional Settings don't affect Excel 2000??

    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

  2. #2
    User3204's Avatar
    Join Date
    Aug 2006
    Location
    Wirral
    Posts
    769
    Thank Post
    55
    Thanked 66 Times in 62 Posts
    Rep Power
    34
    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.

  3. #3
    Samson's Avatar
    Join Date
    Mar 2007
    Location
    Wales
    Posts
    201
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    16
    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.

  4. #4

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,653
    Thank Post
    1,775
    Thanked 2,159 Times in 1,597 Posts
    Rep Power
    768
    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

SHARE:
+ Post New Thread

Similar Threads

  1. Manage Regional Settings via GPO
    By OutLawTorn in forum Windows
    Replies: 5
    Last Post: 5th March 2014, 04:10 PM
  2. Regional Language Settings
    By sLiDeR in forum Windows
    Replies: 3
    Last Post: 31st August 2007, 10:56 PM
  3. Windows Regional Settings
    By Jon in forum Windows
    Replies: 3
    Last Post: 19th January 2007, 12:06 PM
  4. default language and regional settings
    By MManjra in forum ICT KS3 SATS Tests
    Replies: 2
    Last Post: 20th March 2006, 02:30 PM
  5. Replies: 11
    Last Post: 27th September 2005, 12:30 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •