I have a column of dates, they are in yyyymmdd format (no slashes or
anything) and they're text. I cannot format them, how do I do this?

Basically, I want to change 19700429 to 4/29/1970, but for a whole column of
different dates (dates not in sequential order).

Thanks in advance!!!!!