I am trying to import a text file (tab-separated columns) into excel. The log file uses MM/DD/YYYY HH:MM:SS,mmmm
(where mmmm is milliseconds), which excel treats as string.
How can I get excel to recognize it as a date, so I can sue it as X axis for charts, reformat it etc?
(System is W7 Ultimate set to use an English/US UI, Excel is German)
Best Answer
You can add a new column after import and then convert the strings into an Excel datetimes with:
You can also add the fractional part if you need that resolution with:
These examples assume your string is in cell A1.