Help! : Dates in the wrong language

[Nicolas]

Hi,

I've got a problem with my XL for Mac - I've tried absolutely
everything I can think of and can't seem to fix it...

The basic problem is that dates appear in french (specifically, the
month name). This is despite the fact that I've set every preference I
can find to "English".

So 10/07/2006 turns into 10-juil-2006 instead of 10-july-2006.

If I look in the language preferences in excel, it's set to English.
The language preferences in MaxOSX are also set to English. When I
look at the cell format box, it's selected "Date" and the sample format
appears in English (1-Mar-06) in the little window where you can select
the format, but dates still appear in french when I type them into a
cell. Finally, if I look in excel preferences at the "custom lists",
there are four lists which I can't seem to edit, they contain months
and days, and two of them are in French and two of them are in English.

This only started happening recently, and I can't seem to find a way to
get it to stop, and it's clearly driving me bonkers - any help
gratefully received!

 

[Paul Berkowitz]

So 10/07/2006 turns into 10-juil-2006 instead of 10-july-2006.

If I look in the language preferences in excel, it's set to English.
The language preferences in MaxOSX are also set to English.

Go to System Preferences/International/Format.

Set your format Region to United Kingdom or United States. (If this works,
you can come back later and Customize to the exact formats you want for
everything, but for now just stick to a standard format.) Now quit Excel and
relaunch it.

So?

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.