Forum Discussion
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).
Excel language is spanish.
In my older laptop works fine.
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
5 Replies
... 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 https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format or https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/#custom-date-format.
- Thanks.
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
Works but without "proper"
Thank you very muchRuben, 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
