Re:Scientists rename human genes to stop MS Excel from misre...
by baddox on Thursday August 06, 2020 @11:33AM
(#24071838)
If people are just looking at the spreadsheets then wouldn’t the cells interpreted as dates not be a problem? It seems like it would only be a problem if you’re doing computation on the cells.
[ Parent
| on HN ]
Re:Scientists rename human genes to stop MS Excel from misre...
by benhurmarcel on Thursday August 06, 2020 @11:40AM
(#24071923)
Excel changes the displayed text when it interprets the text as date. You store "MARCH1", it displays "1-Mar".