Hello, 

I have a question about importing a csv file to excel. 

When I am importing a csv file in excel, the time does not seem to import right. I convert the text to columns, but the time does something strange. 

First in the csv file it is in minutes and in excel suddenly in seconds. 

Second the numbers who end with a 0 get another number of numbers behind the comma. This results in a different alignment. Which results in that i cannot make the right calculations. These numbers are with a factor 1000 smaller than the numbers who are aligned normal. 

(This happens on a macbook btw)

Does someone maybe know why this happens or knows a solution? 

Thank you in advance!

​Hello, I have a question about importing a csv file to excel. When I am importing a csv file in excel, the time does not seem to import right. I convert the text to columns, but the time does something strange. First in the csv file it is in minutes and in excel suddenly in seconds. Second the numbers who end with a 0 get another number of numbers behind the comma. This results in a different alignment. Which results in that i cannot make the right calculations. These numbers are with a factor 1000 smaller than the numbers who are aligned normal. (This happens on a macbook btw) Does someone maybe know why this happens or knows a solution? Thank you in advance!  Read More

​