I would love to set my default date-setting to be iso 8601 (relevant xkcd) for all of my Google Spreadsheets. I'm well aware that I can manually change the date-format for a given spreadsheet by:
- Selecting the whole sheet, click Format; Number; More formats; 2008-09-26
And it correctly sets the date formatting for that sheet. However, I have to do this for each sheet, and even more annoyingly every new spreadsheet that I create.
My question: How do I set this date format to be my default?