Excel: Changing Format of Odd Date Field


I have a download that posted dates in a way that are hard to read and hard to sort. The cell on the left is how it looks in the download and I would like to make it look like the date on the right. Could anyone help? Much appreciated, Eric

20141015 10/15/2014


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of December 16, 2014.


For more resources for Microsoft Excel