CHANGING A DATE FORMAT FROM yyyymmdd TO mm/dd/yyyy

[jshepherdal]

I have a data set from an AS400 system that has dates formatted in yyyymmdd and I want to convert them to mm/dd/yyyy. How do I do this??

 

[Rick Rothstein]

I have a data set from an AS400 system that has dates formatted in yyyymmdd and I want to convert them to mm/dd/yyyy. How do I do this??

Do you mean you want to convert them "in place" (that is, change for example, 20150609 in cell A1 to 06/09/2015 in cell A1)? If so, select the column with your AS400 dates in them and then call up the Text To Column dialog box (Data tab, Data Tools panel), click Next twice and on the Step 3 of 3, select the Date option button (upper left corner of dialog box) and select YMD from the drop down control next to it, then click the Finish button.