Text format for french date

[Elie Badra]

I have a date cell that I want to incorporate into a paragraph of text. I
would usually use the TEXT(A1,"mmmm dd, yyyy") function but I need this date
to appear in french.
How would I go about doing this?

 

[Pete_UK]

If you had the English months in one column and the French months next
to them like this:

Jan Janvier
Feb Fevrier
Mar Mars
etc

(assume this occupies M1:N12), then you could do:

=VLOOKUP(TEXT(A1,"mmm"),M$1:N$12,2,0)&TEXT(A1," dd, yyyy")

Note that I've only used 3 letters for the English months.

Hope this helps.

Pete

 

[Niek Otten]

This works in Excel 2003 and higher; I don't know what the first version was
where this was possible.

In the Format menu, after you choose Date, you'll find a "Locale" box where
you can choose a language.