View Single Post
Old 08-01-2022, 03:01 PM   #137
Maaka
Bat Boy
 
Join Date: Apr 2016
Location: Sørum, Norway
Posts: 16
Change decimal/separation symbols

I'd like to be able to change decimal symbols, or value separation symbols. When exporting to csv, a lot of data becomes wrong in the spreadsheet, due to the data exported having English values, when the spreadsheet has another language setting. My spreadsheet (and my region of the world) uses comma (,) as a decimal symbol and dot (.) as thousand value separator. When those are reversed, a number like 9.34 (or 9,34 as we'd write it) is displayed as "september 1934", because the spreadsheet interpretes it as a date.
If we're able to modify those decimal and separation symbols, it'd be a lot easier when exporting stats.
Maaka is offline   Reply With Quote