excel - Changing YYYYMMDD to MM/DD/YYYY

Question

So I have a date that is 20170529 but whenever I try to format it to a date, the cell just becomes #########. So normally, that means the column width is too small, but even when I extend the column, it just shows #####

How do I convert these to dates.

Answer 1

=DATEVALUE(TEXT(A1,"0000/00/00"))

and format the result as a date