News for hackers. Stuff that matters.
Re:Cursed Excel: "1/2"+1=45660 by erk__ on Monday April 07, 2025 @02:23PM (#43614397)
How do you make a comma seperated CSV with numbers with commas in them?
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...

Re:Cursed Excel: "1/2"+1=45660 by fragmede on Monday April 07, 2025 @02:30PM (#43614461)
you don't. use SQLite instead
Re:Cursed Excel: "1/2"+1=45660 by silisili on Monday April 07, 2025 @05:13PM (#43616013)
The standard way is to wrap the field in quotes.