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 on...
- 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.
I don't think it's possible to apply different languages format to the same cell, but you may use TEXT() function combining them
