News for hackers. Stuff that matters.

A comment on Human genes renamed to stop Microsoft Excel from misreading them as dates (2020).

Re:Human genes renamed to stop Microsoft Excel from misreadi... by AviationAtom on Monday April 11, 2022 @10:30AM (#30989268)
Isn't this solved by putting a single quote, or something of the sort, in front of the data?
[ Parent | on HN ]
Re:Human genes renamed to stop Microsoft Excel from misreadi... by teh_klev on Monday April 11, 2022 @10:58AM (#30989716)
Yes, but if you're opening a CSV file, some folks don't "import" the CSV which would give you a chance to specify the data types for each column:

https://news.ycombinator.com/item?id=30986868

[ Parent | on HN ]