Hello,
I have a TXT files which has timestamps with milliseconds. The problem is that all values which are less than three digits show up without leading zeroes. So, for example:
2019/9/24, 15:02:08.8
2019/9/24, 15:02:08.9
2019/9/24, 15:02:08.10
2019/9/24, 15:02:08.11
When I try to load the data in excel using h:mm:ss.000 it just appends zeroes to the digits, which is wrong. The problem is compounded by the fact that I also have millisecondd values later on with three digits (i.e. 2019/9/24, 15:02:08.100, 2019/9/24, 15:02:08.101, etc).
Is there a way for me to load the data and fix the column so that all millisecond values show up correctly?
Thanks in advance!
Bookmarks