Forum Discussion
Date format problems
I am working on a data set output from a blood sugar test meter (Bayer Contour Next USB) 1020 rows, 19 columns. Imported as CSV. I want to sort the data by the date column but from row 400 onward ...
Stewart_H some date in date column is import as text for sorting all the date it is essential that all are in date format i used text to column in data tab to convert all your date in date format i have attached a solution file check it,
I'm not sure that is correct result. Let take these two records in initial file
Most probably in #54 in source csv file it was 11/08/2019. Since both 11 and 08 are less than 12, Excel was interpreted $54 as date in local format and converted to Aug 11. Text to Columns on result keeps converted date as it is, thus we have
Most probably in #54 it shall be Nov 08, or 2019-11-08 in ISO format. Same for some other records.
Thus I'd suggest to convert properly source csv file, not to transform intermediate files.
