Hi,

bad import as you forgot to define the column format !

Just activate the Macro Recorder, open the csv text file like a workbook then well answer to the Import Assistant
in particular for the column format (it's the same process if you still use the text to columns convert feature) …