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 ...
Yes, that is the issue. Some of the text will not reformat to date.
The CSV file is created by the software on the blood test meter which is not accesible by me. Can I control how excel converts it when I open the CSV file?
@Khizar_Hayyat has managed to convert all cell to date format but day and month have been mixed up.
@Khizar_Hayyat How did you convert all to date format? Simple explaination for excel novice please.
