Hello,
Normally I work with Excel in Spanish, since most of our PCs have Office in Spanish, however people that don't usually experience difficulties in several formulas like the "=text()" formula.
For example, I'm using this formula to convert a date to text with the following format: "full month name, 4-digit year" but the problem is that if you want to in Spanish you need to write the format like this "mmmm, aaaa" and if you do it in English you need to do it like this "mmmm, yyyy". (año=year)
Since is marked as text due to the quotations marks is not translated like the rest of the formulas.
It's there a way to use this formula without experiencing this kind of issues?
Normally I work with Excel in Spanish, since most of our PCs have Office in Spanish, however people that don't usually experience difficulties in several formulas like the "=text()" formula.
For example, I'm using this formula to convert a date to text with the following format: "full month name, 4-digit year" but the problem is that if you want to in Spanish you need to write the format like this "mmmm, aaaa" and if you do it in English you need to do it like this "mmmm, yyyy". (año=year)
Since is marked as text due to the quotations marks is not translated like the rest of the formulas.
It's there a way to use this formula without experiencing this kind of issues?
