I'm writing this question after reading How to use DATEVALUE with diffent locale setting without changing system settings didn't solve my problem.
It's about reading the correct month from a text created with a different locale. For example the dates come from US locale and I'm using GE locale. Then the months are slightly different:
US months JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC
GE months JAN, FEB, MRZ, APR, MAI, JUN, JUL, AUG, SEP, OKT, NOV, DEZ
I've seen a solution to write a different locale using TEXT function, but I wonder what is the efficient way to do it now. (I consider creating a table or array as last resort ;-)).
Thanks for your hints! +Daniel+