Excel Issue- custom format for Turkish currency

0 votes
Using the Custom format option in Excel, I need to format a column to follow the Turkish currency format (for the Turkish Lira, the decimal separator is a comma(,) and a thousand separator is a dot(. )). I have a custom format for euro currency called "#,##0.00 """"€""""". Please assist with modifying this format to match the Turkish format. The following example illustrates the same:

Value: 1000
Euro Format: 1,000.00 €
Turkish Format: 1.000,00 ₺

Any help would be appreciated.
Oct 10, 2022 in Others by Kithuzzz
• 38,010 points
1,087 views

1 answer to this question.

0 votes

What about:

#.##0,00 [$₺-tr-TR]

Where #.##0,00 € would do for Euro.

enter image description here

answered Oct 10, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

Creating custom property for .net assembly

While your compiler does not really support ...READ MORE

answered Nov 13, 2018 in Others by DataKing99
• 8,240 points
390 views
0 votes
1 answer

Get files in my own file format for its own dynamic icon

Regarding MAC support, "The Mac and Windows ...READ MORE

answered Jan 8, 2019 in Others by DataKing99
• 8,240 points
840 views
0 votes
1 answer

Where is the documentation to refer for coinbase api integration of Etherium coin currency in php?

Hey there! Please refer to the following ...READ MORE

answered Jan 25, 2019 in Others by Omkar
• 69,210 points
511 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
1,288 views
0 votes
1 answer

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,420 points
583 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,237 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,424 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
697 views
0 votes
1 answer

Excel custom format: What does [$€-2] mean?

The 2 in [$€-2] is a "Numeral ...READ MORE

answered Oct 30, 2022 in Others by narikkadan
• 63,420 points
247 views
0 votes
1 answer

Custom Request Matcher for SEOMOZ + VCR

record the time of the test in ...READ MORE

answered Feb 25, 2022 in Others by narikkadan
• 63,420 points
271 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP