SOLVED

DATE IN SPANISH

Copper Contributor

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.

5 Replies
best response confirmed by Ruben Coldman (Copper Contributor)
Solution

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 much

 

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

@Ruben Coldman 

 

... 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.

Thanks.
1 best response

Accepted Solutions
best response confirmed by Ruben Coldman (Copper Contributor)
Solution

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

 

View solution in original post