News for hackers. Stuff that matters.
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?
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.
Re:Scientists rename human genes to stop MS Excel from misre... by rini17 on Thursday August 06, 2020 @03:19PM (#24074462)
LibreOffice, on opening of CSV file, always pops an import dialog where you can do this. To keep the column format permanently, save as ods.