Oct 25 2020 11:56 PM
Hi everyone
I have lots of data info in my data and when I write 11.11.2020 - 12:00 in a cell
It seems like that:
Wednesday (Wed) 11.11 - Saat: 12.00 |
But I need to see the first one in turkish like below:
Çarşamba (Wed) 11.11 - Saat: 12.00 |
Also added an example file to understand you better how it seems on my data now
If you know a way to do that pls let me know
Oct 26 2020 12:33 AM
TT.MM.JJJJ, - "Saat:" hh.mm [$-tr-TR]TTTT
In the inserted file you will find an example and the code setting for different countries.
I also wish you a lot of fun with Excel and your plans.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Oct 26 2020 12:56 AM
Oct 26 2020 01:00 AM
Tt. MM.YYYY, - "Seed:" hh.mm [a-tr-TR]TTD -> when I tried to this formula all sentence written in English but I need to see like below format:
Turkish (Eng) 11.11 - "Saat" 12.00
Çarşamba (Wed) 11.11 - Saat: 12.00
I'm looking a way to see both Turkish and English in same cell when I write just the date and clock
Oct 26 2020 01:02 AM
I dont need to change my language settings this is not the issue
I'm looking a way to see both Turkish and English in same cell when I write just the date and clock
Oct 26 2020 01:17 AM
I don't think it's possible to apply different languages format to the same cell, but you may use TEXT() function combining them
Oct 26 2020 01:55 AM