English day and month names in Italian sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dario de Judicibus - 16 Oct 2007 11:25 GMT

I use the Italian version of Excel. If I enter a date in a cell and I select
a format that shows the month name, I get the Italian version of name, for
example

martedì 16 ottobre 2007

rather than

tuesday 16 october 2007

If my sheet is written in English and I convert the sheet to a PDF document
to send to USA, the date still shows the Italian name of days and months.
So, how can I tell Excel to use the English names without changing the
operating system locale just to print a file? Please, note that I need to do
that ONLY for some file, since in most cases Italian formats are ok for me.

Dario de Judicibus
www.dejudicibus.it
www.lalamanera.it

Reply to this Message

arno - 16 Oct 2007 16:09 GMT

> martedì 16 ottobre 2007
>
> tuesday 16 october 2007

Hi,

there are worksheet-functions you can use to split the date into numbers for
weekday and month. Use them in a table with translated names for weekdays
and months. "read" your tables with vlookup and concatenate the english
date.

eg.

a1: 16.10.2007

a2: =weekday(a1, 1) will give you numbers from 1 to 7

a3 =month(a1) will give you months from 1 to 12.

a4 = day(a1) will give you the day of the month,
a5 = year(a1) the year.

table for days
1 monday
2 tuesday
....

table for months
1 january
2 february
....

in b2, b3, b4, b5 write the vlookups and the day and year. Create the full
date with something like

c1: =b2&", "&b4&". "&b3&" "&a5

HTH

arno

Reply to this Message

arno - 17 Oct 2007 08:16 GMT

Hi again,

there is an easier method (here for german months)

=choose(month(A1);
"Januar";"Februar";"März";"April";"Mai";"Juni";"Juli";"August";"September";"Oktober";"November";"Dezember")

thanks to

>> martedì 16 ottobre 2007
>>
[quoted text clipped - 36 lines]
>
> arno

Reply to this Message

Rate this thread: