I have a column with over 1000 entries in a 8 digit number format, which should represent a date.
e.g 20050214
should represent 14th February 2005,
or even 2005-02-14

However I have no luck in converting all these entries using the formating option to represent at date. Unless I manually input a "-" between 2005 02 14

Please advise!