DATE FORMATTING ISSUE

[Anıl Adaş]

According to my format settings, the excel shows me like "Perşembe 14.11 - 12:00" when I write "14.11.2019 12:00" on A1 in attached example.

Perşembe means Thursday in Turkish language so it shows Perşembe in A1 because the user of my file is a turkish and use excel in their local language.

I need to show him a combined format including both Turkish and English like "Perşembe (Thu) 14.11 - 12.00" in C1

It looks lile very simple but I couldnt find a way to set a combined format on cells, please help me if you know a method for this

[#2]

@Anıl AdaşUse this.

=TEXT(A1,"ddddddd dd/mm - hh:mm")&" "&TEXT(C1,0)

[#3]

@Anıl Adaş 

You may try the following custom number formatting to display the date in the desired format...

dddd ([$-en-US]ddd) dd/mm - hh:mm