Forum Discussion
How to see a date with different languages on the cell
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
6 Replies
- Do the following (for Windows 7 and higher) :
- Go to Control panel.
- Hit Clock, Language, and Region.
- Under Region and Language Tab find & hit Location.
- Find and set the country name form the list.
- You may set the keyboard language also.
- For older versions:
- Control panel.
- Date & Time.
- Language and Regional Option.
- Set the Country.
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
- Two different cell formats are usually not allowed by Excel in a cell but, you have to do some trick, store values in two different cells and use "Concatenate" to pull into a cell.
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.
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
