CODEWITHSUNDEEP
excelexcel-formulaformattingcurrency-formattingcustom-formatting
OSlearner
OSlearner

Reputation: 1

Excel Issue- custom format for Turkish currency

I need to format a column in excel to adhere to Turkish currency format using the Custom format option available in Excel(for Turkish Lira, the decimal separator is comma(,) and thousand separator is dot(.)). I have "#,##0.00\ """"€""""" custom format for Euro currency. Could someone please help in changing this format to conform to the Turkish format? Example for the same is given below:

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

Thank you for your help!

Upvotes: 0

Views: 1411

Answers (1)

JvdV
JvdV

Reputation: 75960

What about:

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

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

enter image description here

Upvotes: 1

Related Questions