How to set a locale to use comma as decimal separator and Euro as currency symbol by default

Question

Here is my issue :

• We work in English
• We are a French company : we want Euro as default currency...
• ... and the "French formatting" for dates (dd/mm/yyyy) and numbers (1 thousand = 1 000,00 ; not 1,000.00).
.. Which is by the way, the standard in continental Europe if I am correct.

I cannot get the default language and country to work correctly :

• I set defaults that should work (language = English, country = whatever country in continental Europe) in : myaccount / language (as found on Google support page)
• ... But when I create a new Spreadsheet (from Drive > new spreadsheet) it is created as "locale = UK" (hence currency is £/GBP, I want Euro). And this is for every country in continental Europe... 
The only country that is not switched to UK is Ireland, but the numbers formatting is not what I want (problem with comas ",").

This matters because as comas are not used similarly, it is "a small pain every time we copy/paste figures", same with dates. Hence we change every single new document's locale. 1 min on almost every new Spreadsheet to understand why your formulas don't work and manually correct, this is irritating!

---

For references, I have looked at these webapps.stackexchange questions that seem close but do not address this specific problem:

• Change Google Sheets default date format with other locale
• Setting up decimal separator, thousand separator and date in Google Spreadsheets
• How does one set the default locale for each new spreedsheet in Google Sheets?

---

And also for the reference, a similar question on support.google.com/docs/:

• What locale has English as its language and comma as decimal separator by default?

Answer 1

It looks that you did a great research job. So far don't know if there is a locale having the settings that you want, so here are some workarounds:

1. Create a spreadsheet with the desired settings, share it with your co-workers as viewers and instruct them to make a copy of this spreadsheet to avoid having to manually set the spreadsheet settings.

2. Publish the above spreadsheet as a template. If you are using Google Workspace account you my publish your template in the organization template gallery.

3. Use a Google Workspace Editor add-on for Google Sheets that make it easier to apply the desired settings. If you are using a Google Workspace accounts you might might create a internal add-on by using Google Apps Script without having to request a OAuth review by Google.

4. Make a script using Google Apps Scripts to set the desired settings. You could create a library to make easier to maintain the core script and include on each spreadsheet a small script to call the corresponding function(s) from the library.

Some clarifications:

• You could set the Google account language to French or any other language that you want and your spreadsheet settings to use any locale.
• When using an account different other than English each user could set Google Sheets to show functions in English. This setting is by user, not by spreadsheet, meaning that for the same spreadsheet one user could see functions in French and another in English.
• If you will use Google Apps Script to add or modify formulas, the script should use English function names.