I have a report where the cells are in text in this format "2018021409012900" it is YYYYMMDDHourHourMinMin. The last four digits are milliseconds which I don't need.
I need to convert this to a date & time cell that is more legible.
I can think of some labor intensive ways to do this, but I...