Jul 06 2020 07:53 AM - edited Jul 06 2020 07:55 AM
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?