View Single Post
  #1   Report Post  
IanC
 
Posts: n/a
Default TEXT function to format a date in English & French

I have cells formatted with TEXT and the format_text "mmmm yyyy".
Unfortunately this does not work in Europe as they expect (say in France)
"mmmm aaaa". Is there any way around this to use TEXT in more than 1
language?