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)
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)