Oct 15 2018 10:08 AM
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).
Excel language is spanish.
In my older laptop works fine.
Oct 15 2018 10:36 AM
SolutionHi 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
Oct 17 2018 07:48 AM
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
Jun 27 2022 06:54 AM
... to change dates from English to Spanish, use this format in Format Cells>Number>Custom type: [$-1540A]dddd mmmm d;@.
This particular example gives you sábado junio 18 (you know than in Spanish, day and month names are not capitalized). Change/add the day/dates/month/year format as wanted; full details are in How to change Excel date format and create custom formatting (ablebits.com) or https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format.
Oct 15 2018 10:36 AM
SolutionHi 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