Importing CSV with timestamps dd.mm.yy hh:mm:ss.000

Copper Contributor

Hi

I'm generating with a script a CSV-File containing timestamps in following format:

dd.mm.yy hh:mm:ss.000

Example: 02.07.2020 06:06:56.265

 

Excel imports the string mostly correct and coverts it into a timestamp.

But if the milliseconds begin with a 0 (Zero) it stays a string.

Example: 02.07.2020 05:55:14.034

 

How can I configure excel, so it converts all of the correctly?

0 Replies