Hi everybody!
I hope someone can help me with a problem I came across.
I have a set of data that are supposed to be dates but are originally written in a way that excel cannot format it as a date (at least I don't know how to).
Eg it is written 1062018 (that is supposed to be 1st June 2018) or 28112017 (28th November 2017) or 20042018 (20th April 2018).
I would really appreciate it if someone could teach me how to make those cells to be in a date format (any format of date is fine) just so that I am later able to sort and filter the data by date.
Thank you all so much in advance!
Bookmarks