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 in Others by Kithuzzz
• 20,660 points
119 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 by narikkadan
• 37,660 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
234 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
607 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
319 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 in Others by gaurav
• 22,040 points
518 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 in Others by narikkadan
• 37,660 points
58 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 in Others by Edureka
• 13,640 points
140 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 in Others by Edureka
• 13,640 points
236 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 in Others by Edureka
• 13,640 points
106 views
0 votes
1 answer

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

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

answered Oct 30 in Others by narikkadan
• 37,660 points
34 views
0 votes
1 answer

Custom Request Matcher for SEOMOZ + VCR

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

answered Feb 25 in Others by narikkadan
• 37,660 points
69 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