View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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?