View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?