Re:Cursed Excel: "1/2"+1=45660
by rickdeckard on Monday April 07, 2025 @03:12PM
(#43614823)
A comma separated CSV with decimal numbers uses a dot as a decimal point (US regional setting)
A German CSV uses a semicolon as a separator and a comma as a decimal point (German regional setting)
To create a US-style CSV on a German PC (with expectation to create a common CSV format) you need to change the regional setting of Windows before opening Excel...
A German CSV uses a semicolon as a separator and a comma as a decimal point (German regional setting)
To create a US-style CSV on a German PC (with expectation to create a common CSV format) you need to change the regional setting of Windows before opening Excel...