Hello, I am trying to convert an integer “20190814” in excel to a date format in excel.
I tried using excel to convert it to a date format but it returns as “######”. Is there anyway where I can insert “/” or “-” between the yyyy-mm-dd ? Or is there any other way to do it?
Thanks in advance!