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

%3CLINGO-SUB%20id%3D%22lingo-sub-1505295%22%20slang%3D%22en-US%22%3EImporting%20CSV%20with%20timestamps%20dd.mm.yy%20hh%3Amm%3Ass.000%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505295%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI'm%20generating%20with%20a%20script%20a%20CSV-File%20containing%20timestamps%20in%20following%20format%3A%3C%2FP%3E%3CP%3Edd.mm.yy%20hh%3Amm%3Ass.000%3C%2FP%3E%3CP%3EExample%3A%2002.07.2020%2006%3A06%3A56.265%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20imports%20the%20string%20mostly%20correct%20and%20coverts%20it%20into%20a%20timestamp.%3C%2FP%3E%3CP%3EBut%20if%20the%20milliseconds%20begin%20with%20a%200%20(Zero)%20it%20stays%20a%20string.%3C%2FP%3E%3CP%3EExample%3A%2002.07.2020%2005%3A55%3A14.034%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1505295%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

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