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?
|