News for hackers. Stuff that matters.
Re:Scientists rename genes to stop Microsoft Excel from misr... by sparkie on Tuesday March 26, 2024 @02:12PM (#39830986)
You don't even need to do that. Just stick a single ' before any number/date and it will be treated as text.

The problems are when importing/exporting though. Even quoted numbers will lose the quote when exported to say, CSV. You need to explicitly save as quoted, and import quoted fields as text. The real issue is that these settings are not the default.

In LibreOffice (Save/Open CSV): https://imgur.com/a/ved7wgA

There are no comments on this comment yet.