5 ms·
I have an even better one for you — if the language/region of your system is different, Excel parses the file differently. My example, Slovak region, numbers ar
by kubik369 3y ago
I have an even better one for you — if the language/region of your system is different, Excel parses the file differently. My example, Slovak region, numbers are officially written with a comma — 1,3 meaning a decimal "one point three". When you open a file that has the numbers from a different region (so 1.3), it completely falls apart.
- towawy 3y agoWorkaround for anyone struggling with this: Use the Import feature from the Files menu instead of the usual Open dialog for csv files. You can change decimal separators in the import wizard.
- andersa 3y agoThis is one of those things that make absolutely no sense. The "."/"," difference should only apply to displaying numbers to users like any other localization related change. Why on earth is it writing numbers differently in a standard format meant to be read only by computers? Such a colossal fuckup making csv files always broken for half of Excel users.