English day and month names in Italian sheet

  • Thread starter Thread starter Dario de Judicibus
  • Start date Start date
D

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
 
martedì 16 ottobre 2007
tuesday 16 october 2007
Click to expand...

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
 
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
 
Back
Top