Forum Discussion

Copper Contributor

Oct 15, 2018

Solved

DATE IN SPANISH

In my new laptop, using the same excel and the same template, the funtion TEXTO(A6,"ddd dd mmm") returns the name of the day in english ("Sunday", etc) and I need it in spanish ("Domingo", etc). E...

excel

Formulas and Functions

SergeiBaklan
Oct 15, 2018
Hi Ruben,

Perhaps that's due to your Windows settings, but in any case you may add locale identifier to the formula like
=PROPER(TEXT(A6,"[$-es-es]ddd dd mmm"))
More is here https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format

SergeiBaklan

Diamond Contributor

Oct 15, 2018

Hi Ruben,

Perhaps that's due to your Windows settings, but in any case you may add locale identifier to the formula like

=PROPER(TEXT(A6,"[$-es-es]ddd dd mmm"))

More is here https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format

Ruben Coldman

Copper Contributor

Oct 17, 2018

Works but without "proper"

Thank you very much

SergeiBaklan
Diamond Contributor
Oct 17, 2018
Ruben, you are welcome.

In some cases formula returns only lowcase text like "wed 10 oct". PROPER is to shift first letters to uppercase, like "Wed 10 Oct". You may check here https://en.excel-translator.de/translator/ how formula looks in Spanish