Date Problems

[Andrea Jones]

I'm using Excel 2000 SP3 on an NT4 machine with SP6. I've
set the Windows regional settings to English(UK) and the
Microsoft Office Language Settings to English(UK).
Despite this, I can only get American date formats when
formatting in Excel. The About in Excel says the language
is English (United States) despite the Office Language
Settings being English(UK). How can I fix this?

 

[Norman Harker]

Hi Andrea!

Save and close everything.
Re-check that you have English(UK) Regional setting
Re-check your Date tab in Regional settings to make sure that it is
using (e.g.) dd-mm-yyyy
Make sure you press "Apply"

Then close down the computer and re-start.

Check and report back.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Andrea Jones]

Done all that, set regional settings to UK, used Apply and
then OK, changed Office Language to English(UK), Excel
About System Info still says Office language is English
(United States), I then changed everything back to US and
then back to UK again but it still won't budge.

Andrea Jones

 

[Norman Harker]

Hi Andrea!

Here's something from Help:

You can change your default settings in Microsoft Office to have them
match the default settings of a different language.

1.. In Microsoft Windows XP, on the Windows Start menu, point to All
Programs, point to Microsoft Office, point to Microsoft Office Tools,
and then click Microsoft Office 2003 Language Settings.

In Windows 2000, on the Windows Start menu, point to Programs, point
to Microsoft Office, point to Microsoft Office Tools, and then click
Microsoft Office 2003 Language Settings

2.. Click the Enabled Languages tab.
3.. In the Choose the language that defines default behavior in
Microsoft Office applications box, select the language you want, and
then click OK.

4.. A message appears describing the effects of the change. To
continue, click Continue and lose customizations.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.