3 ms·
Great, how do you set a custom column format in a CSV file?
by zozbot234 6y ago
Great, how do you set a custom column format in a CSV file?
- ryukafalz 6y agoI'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.
- rini17 6y agoLibreOffice, on opening of CSV file, always pops an import dialog where you can do this. To keep the column format permanently, save as ods.