Questions tagged [google-sheets-settings]

Use for questions about Google Sheets spreadsheet settings like regional settings (decimal separator, default currency and date format), timezone, etc.

Filter by
Sorted by
Tagged with
3 votes
1 answer
707 views

Google Sheets: On change, delete a specific row if a certain cell is blank

I have a tab on a spreadsheet where if you add a new row to the first row specifically, it breaks the formulas in that tab as they are on the first row. Therefore, if someone adds a row to row 1, I ...
dea's user avatar
  • 63
1 vote
1 answer
2k views

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

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 ...
sebastien.worms's user avatar
2 votes
2 answers
8k views

Set calculation precision in Google Sheets

Google Sheets uses some sort of floating point arithmetic in its internal calculation, even if only integer numbers are in the calculation. For example: A1: =128^128 A2: =A1+1 A3: =A2-A1 Then, A3 ...
Andreas Petersson's user avatar
35 votes
2 answers
111k views

Setting up decimal separator, thousand separator and date in Google Spreadsheets

Is there a way to change settings of decimal separator, thousand separator and date format in Google Sheets? I would like to have: dots for decimal, space for thousand date in format YYYY-MM-DD....
Przemyslaw Remin's user avatar
11 votes
2 answers
5k views

Why does the official documentation for Sheets functions incorrectly use commas to separate parameters?

Why does the Google Sheets documentation for functions incorrectly use commas instead of semicolons to separate parameters? For example, the documentation for =SORT gives the usage example: =SORT(A2:...
pong's user avatar
  • 229
6 votes
1 answer
6k views

Google Spreadsheets: IF not working

I have problems with my IF command in Google Sheets. If gives #ERROR! all the time. See this simple test: Not even if I put in the number directly and avoid references: Am I using the IF wrong? Or ...
Steeven's user avatar
  • 600