News for hackers. Stuff that matters.
Re:Scientists rename genes to stop Microsoft Excel from misr... by mike_hearn on Tuesday March 26, 2024 @05:59AM (#39825954)
You can write CSVs in such a way that forces Excel to infer specific data types:

"=""Data Here"""

will always be treated as a string. This is also supported by Sheets, apparently.

Re:Scientists rename genes to stop Microsoft Excel from misr... by _visgean on Tuesday March 26, 2024 @08:23AM (#39826961)
ok but will that work other tools that work with those csvs? I imagine that they export / import from excel to csv for a reason.
Re:Scientists rename genes to stop Microsoft Excel from misr... by mcintyre1994 on Tuesday March 26, 2024 @07:49AM (#39826690)
TIL, neat! Does Excel automatically export like that if you format the columns as strings?