DOB help

[hawilder]

Hello

Does anyone know how to take a column of yyyymmdd format 19970522 and change it all to exactly mm/dd/yyyy (with lines) ? I need to upload a pretty large file in this format and the raw data is in the wrong yyyymmdd format.

Thanks for helping!
H

 

[Andrew Poulsom]

You should be able to use Data|Text To Columns, selecting Date YMD at Step 3.

 

[hawilder]

THANK YOU!!! i thought that would split it into columns .... worked .