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.
|