Re: Date Formatting Won't Change

IMHO, bit easier use Text to Columns as mentioned above (select column A, Data->Text to Columns, on third step of the wizard select Date and MDY)

If formula conversion is more preferable, we may cut number of steps using

=DATE( RIGHT(A2,4), LEFT(A2,2), MID(A2,4,2) )

which returns the date directly.