convert non-date format to date format

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert date from string to date format 3
date format convert 2
Default date format 4
How to enter a date in DD-MM-YYYY format 2
convert date 1
Date Format Problem. 2
Date format 1
convert to date format 3

Top