English day and month names in Italian sheet

[Dario de Judicibus]

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

 

[arno]

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

 

[arno]

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