Excel Issue- custom format for Turkish currency

Question

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.

Answer 1

What about:

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

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