How to see a date with different languages on the cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1817326%22%20slang%3D%22en-US%22%3EHow%20to%20see%20a%20date%20with%20different%20languages%20on%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817326%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20lots%20of%20data%20info%20in%20my%20data%20and%20when%20I%20write%2011.11.2020%20-%2012%3A00%20in%20a%20cell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20like%20that%3A%3C%2FP%3E%3CTABLE%20width%3D%22302px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22301.333px%22%3EWednesday%20(Wed)%2011.11%20-%20Saat%3A%2012.00%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20need%20to%20see%20the%20first%20one%20in%20turkish%20like%20below%3A%3C%2FP%3E%3CTABLE%20width%3D%22267px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22266px%22%3E%C3%87ar%C5%9Famba%20(Wed)%2011.11%20-%20Saat%3A%2012.00%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20added%20an%20example%20file%20to%20understand%20you%20better%20how%20it%20seems%20on%20my%20data%20now%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20know%20a%20way%20to%20do%20that%20pls%20let%20me%20know%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1817326%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1817430%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20see%20a%20date%20with%20different%20languages%20on%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817430%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F161700%22%20target%3D%22_blank%22%3E%40An%20el%20Adao%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETt.%20MM.YYYY%2C%20-%20%22Seed%3A%22%20hh.mm%20%5Ba-tr-TR%5DTTD%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20inserted%20file%20you%20will%20find%20an%20example%20and%20the%20code%20setting%20for%20different%20countries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20wish%20you%20a%20lot%20of%20fun%20with%20Excel%20and%20your%20plans.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1817474%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20see%20a%20date%20with%20different%20languages%20on%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817474%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F161700%22%20target%3D%22_blank%22%3E%40An%C4%B1l%20Ada%C5%9F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EDo%20the%20following%26nbsp%3B%20(for%20Windows%207%20and%20higher)%20%3A%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3COL%3E%3CLI%3E%3CSPAN%3EGo%20to%20Control%20panel.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EHit%20Clock%2C%20Language%2C%20and%20Region.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EUnder%20Region%20and%20Language%20Tab%20find%20%26amp%3B%20hit%20Location.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EFind%20and%20set%20the%20country%20name%20form%20the%20list.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EYou%20may%20set%20the%20keyboard%26nbsp%3B%20language%20also.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CUL%3E%3CLI%3E%3CSPAN%3EFor%20older%20versions%3A%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3COL%3E%3CLI%3E%3CSPAN%3EControl%20panel.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EDate%20%26amp%3B%20Time.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3ELanguage%20and%20Regional%20Option.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3ESet%20the%20Country.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1817476%22%20slang%3D%22en-US%22%3EBetreff%3A%20How%20to%20see%20a%20date%20with%20different%20languages%20on%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817476%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETt.%20MM.YYYY%2C%20-%20%22Seed%3A%22%20hh.mm%20%5Ba-tr-TR%5DTTD%20-%26gt%3B%20when%20I%20tried%20to%20this%20formula%20all%20sentence%20written%20in%20English%20but%20I%20need%20to%20see%20like%20below%20format%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETurkish%20(Eng)%2011.11%20-%20%22Saat%22%2012.00%3C%2FP%3E%3CP%3E%C3%87ar%C5%9Famba%20(Wed)%2011.11%20-%20Saat%3A%2012.00%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20a%20way%20to%20see%20%3CSTRONG%3Eboth%20Turkish%20and%20English%20in%20same%20cell%3C%2FSTRONG%3E%20when%20I%20write%20just%20the%20date%20and%20clock%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

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
Highlighted

@Anıl Adaş 

 

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.

Highlighted

@Anıl Adaş 

 

  • Do the following  (for Windows 7 and higher) : 
  1. Go to Control panel.
  2. Hit Clock, Language, and Region.
  3. Under Region and Language Tab find & hit Location.
  4. Find and set the country name form the list.
  5. You may set the keyboard  language also.
  • For older versions:
  1. Control panel.
  2. Date & Time.
  3. Language and Regional Option.
  4. Set the Country.
Highlighted

@Nikolino 

 

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

Highlighted

@Rajesh-S 

 

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

 

Highlighted

@Anıl Adaş 

I don't think it's possible to apply different languages format to the same cell, but you may use TEXT() function combining them

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