Issue with BigQuery saving results as Google Sheets: some floating points number are messed up

[ailton_oliveira]

Hello,

I am from Brazil where we use comma "," as decimal separator and a point "." as thousands separator.

When using the BigQuery console (URL Removed by Staff) and saving query results as "Google Sheets" some floating point numbers get "messed up". One example, a value like "5322,508745079" appears on the sheet as "5322508745079" and when I apply a format to it, it turns to

"5.322.508.745.079". I tried to change my settings on the google cloud console (URL Removed by Staff) but I was unable to workaround it.

I have changed the language to English, have chosen the number format corresponding to a decimal separator as a point. I have tried thousands separator as comma and without thousands separator to no avail.

I guess that only numbers with "many" significant digits are effected but I don't have a reproducible example.

Someone here have faced a similar issue?

Thanks.