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.

Sunday Obri wrote:
>
> 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?

--

Dave Peterson