10 ms·
Decimal points vs decimal commas is a common problem here (and other countries with similar locale details) with software, when exporting numbers in text format
by Jare 13y ago
Decimal points vs decimal commas is a common problem here (and other countries with similar locale details) with software, when exporting numbers in text format to be processed by other software. Over the years I have had to correct for this in 3DSMax and Excel scripts. Very annoying.
- teamonkey 13y agoIt doesn't matter which format of CSV file you choose, or what settings you use, what Excel actually saves will be different depending on the language profile of the individual user. Not useful in a bilingual office, especially if you want a script to parse that CSV. My simple hack was to create a macro button that saves to CSV, because the macro function ignores the language settings (probably a bug?) and always saves in the English format.