convert non-date format to date format

  • Thread starter Thread starter Sunday Obri
  • Start date Start date
S

Sunday Obri

I am working on a data with over 4000 observations, unfortunately. The
database program from with the dataset was imported from
stores dates as 20080124 20080730
20080730
20080730
20080730
20080730
20080730
20090202
20090202
20080730
20080730
How do I convert this date format to mm/dd/yyyy with having it to do it
manually?
 
If it's one column of data, you can:
Select the column
Data|Text to columns
Fixed width
Date (ymd)
and plop it right back where you got it.

Then format it the way you like.

If you have multiple columns to convert, just repeat for each column.
 
Back
Top