Re:Scientists rename human genes to stop MS Excel from misre...
by zozbot234 on Thursday August 06, 2020 @12:58PM
(#24072881)
Great, how do you set a custom column format in a CSV file?
[ Parent
| on HN ]
Re:Scientists rename human genes to stop MS Excel from misre...
by ryukafalz on Thursday August 06, 2020 @03:18PM
(#24074451)
I'm only familiar with LibreOffice and not Excel myself, but: if you want to be sure a column is treated as text in a CSV file, you have LO quote text fields on save, and have it treat quoted fields as text on import. I assume Excel must have similar options.