Date in a different language

[Guest]

Hi.
My PC is in Italian language. In a file of Excel I need to get the dates in
English.
I have set the date format as follows: [$-409]gggg, mmmm gg, aaaa
which gives the following result: Venerdì, Aprile 21, 2006
That is, the date actually in English format, but in Italian language...
In My PC the English language is already available: What have I to do now to
set this specific file in English language?

Thanks in advance.
CIAO

 

[Guest]

You could use the DATE function and other text functions to create the date
in the language you want.

I used the following formula to switch between USA and England date formats
once.

=DATE(RIGHT(A2,4),LEFT(A2,(FIND("/",A2,1))-1),MID(A2,(FIND("/",A2,1))+1,(FIND("/",A2,(FIND("/",A2,1))+1))-(FIND("/",A2,1))-1))

Or you could change the regional settings on your PC when you work on the
file you are talking about.

Bill Horton

 

[Guest]

Thanks a lot William,

In the meantime I came to know that In Office 2003 I can set the date in
English by setting the format of the date as follows:
[$-409]gggg, mmmm gg, aaaa

The problem is that I have OFFICE 2000, with wich that formula does not work.
The guide in office 2000 mentions the option of changing the language, but
I'm not able to understand how to do. Maybe there is a different formula to
insert or some additional operation to do in order to activate that function.

HELP!!!

You could use the DATE function and other text functions to create the date
in the language you want.

I used the following formula to switch between USA and England date formats
once.

=DATE(RIGHT(A2,4),LEFT(A2,(FIND("/",A2,1))-1),MID(A2,(FIND("/",A2,1))+1,(FIND("/",A2,(FIND("/",A2,1))+1))-(FIND("/",A2,1))-1))

Or you could change the regional settings on your PC when you work on the
file you are talking about.

Bill Horton

Hi.
My PC is in Italian language. In a file of Excel I need to get the dates in
English.
I have set the date format as follows: [$-409]gggg, mmmm gg, aaaa
which gives the following result: Venerdì, Aprile 21, 2006
That is, the date actually in English format, but in Italian language...
In My PC the English language is already available: What have I to do now to
set this specific file in English language?

Thanks in advance.
CIAO