Define a number format in google spreadsheets

Question

i am struggling to define a number format for a cell on google spreadsheets. I want to just add the number format for the currency € Euro, so that i receive the following separator in the following case:

200.000,00€

I couldn't manage it until now i always got back the english separating way of this number.

Answer 1

Your profile doesn't say where you are, but you can go to File | Spreadsheet Settings | Locale and change it to (say) Germany. Note that this will change the settings for all decimal numbers, currency values and dates across the spreadsheet though.