Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
French format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
How do I format numbers for French-style in Excel v.X for mac? | Excel Discussion (Misc queries) | |||
DATE.DIFF results in French | Excel Discussion (Misc queries) | |||
TEXT function to format a date in English & French | Excel Worksheet Functions |