If you are using the TEXT worksheet function because it is part of a larger formula then you can instruct the function itself to use a different language for its output. A is the status quo dissatisfaction. You do this by including a language code formally called an LCID within brackets in this manner.
Excel Translate is a function that helps to convert one language to another.
INDEXtblLangLangIDMATCHLangSeltblLangLang0 When English is selected the result is 1 and 2 for French. The original formula as created by Gleicher and published by Richard Beckhard see Attribution confusion below is. I have written the formula in the B2 cell only and copied to B6 cell as follows. Mine is french but the most important is german.