Home

DATE FORMATTING ISSUE

%3CLINGO-SUB%20id%3D%22lingo-sub-983130%22%20slang%3D%22en-US%22%3EDATE%20FORMATTING%20ISSUE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-983130%22%20slang%3D%22en-US%22%3E%3CP%3EAccording%20to%20my%20format%20settings%2C%20the%20excel%20%3CSTRONG%3Eshows%20me%3C%2FSTRONG%3E%20like%20%3CSTRONG%3E%22Per%C5%9Fembe%2014.11%20-%2012%3A00%22%3C%2FSTRONG%3E%20when%20%3CSTRONG%3EI%20write%20%2214.11.2019%2012%3A00%22%20on%20A1%3C%2FSTRONG%3E%20in%20attached%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EPer%C5%9Fembe%20means%20Thursday%3C%2FSTRONG%3E%20in%20Turkish%20language%20so%20it%20shows%20Per%C5%9Fembe%20in%20A1%20because%20the%20user%20of%20my%20file%20is%20a%20turkish%20and%20use%20excel%20in%20their%20local%20language.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20show%20him%20%3CSTRONG%3Ea%20combined%20format%20including%20both%20Turkish%20and%20English%3C%2FSTRONG%3E%20like%20%3CSTRONG%3E%22Per%C5%9Fembe%20(Thu)%2014.11%20-%2012.00%22%20in%20C1%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20looks%20lile%20very%20simple%20but%20I%20couldnt%20find%20a%20way%20to%20set%20a%20combined%20format%20on%20cells%2C%20please%20help%20me%20if%20you%20know%20a%20method%20for%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-983130%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-1048884%22%20slang%3D%22en-US%22%3ERe%3A%20DATE%20FORMATTING%20ISSUE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1048884%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%3EUse%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%3DTEXT(A1%2C%22ddddddd%20dd%2Fmm%20-%20hh%3Amm%22)%26amp%3B%22%20%22%26amp%3BTEXT(C1%2C0)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1048966%22%20slang%3D%22en-US%22%3ERe%3A%20DATE%20FORMATTING%20ISSUE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1048966%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%3EYou%20may%20try%20the%20following%20custom%20number%20formatting%20to%20display%20the%20date%20in%20the%20desired%20format...%3C%2FP%3E%3CP%3E%3CSTRONG%3Edddd%20(%5B%24-en-US%5Dddd)%20dd%2Fmm%20-%20hh%3Amm%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

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 Replies

@Anıl AdaşUse this.

 

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

 

 

Highlighted

@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

Related Conversations
Bug - owner can't manage tags
Konrad92 in Microsoft Teams on
0 Replies
Edge Canary Version 82.0.456.0 Collection
HotCakeX in Discussions on
0 Replies
What does backed off status mean in Edge sync?
HotCakeX in Discussions on
0 Replies
Documentation Migration
SunLeo in Office 365 on
0 Replies