Text format for french date
 

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?

Text format for french date
 

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

On Nov 5, 6:54*pm, Elie Badra
wrote:
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?

Text format for french date
 

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.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Elie Badra" wrote in message
...
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?