News for hackers. Stuff that matters.

A comment on Missing Covid-19 test data was caused by the ill-thought-out use of Excel. Parent comment

Re:Missing Covid-19 test data was caused by the ill-thought-... by jugg1es on Tuesday October 06, 2020 @10:16AM (#24697841)
How? Where is the setting to turn it off when initially loading a file?
[ Parent | on HN ]
Re:Missing Covid-19 test data was caused by the ill-thought-... by jasode on Tuesday October 06, 2020 @10:35AM (#24698071)
>How? Where is the setting to turn it off when initially loading a file?

Confusion is happening because 2 different ideas of Excel using csv files:

- you saying "can't turn this off" : File Explorer double-clicking a "csv" or MS Excel "File->Open" csv.

- others saying "you can preserve leading zeros" : click on Excel 2019 Data tab and import via "From Text/CSV" button on the ribbon menu and a dialog pops up that provides option "Do not detect data types" (Earlier version of Excel has different verbiage to interpret numbers as text)

[ Parent | on HN ]