Importing CSV with timestamps hh:mm:ss.000'
Regular Visitor


I'm generating with a script a CSV-File containing timestamps in following format: 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