Date formats

G

Guest

I received a file with dates as follows 08011944 or August 1, 1944 and I need
to convert it to a true date format 8/1/1944 to use it in other files. I
can't simply format it as a date as it isn't recognized as such. Any help in
how to convert would be appreciated.
 
G

Guest

Select the column with the dates, do data>text to columns, click next twice
and under column data format select Date and then MDY or DMY depending on if
you are using US or British dates, click finish


Regards,

Peo Sjoblom
 

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

Date conversions....Excel thinking too hard? 1
Input date format 1
Need to open eer file without converting 8-7440 to a date? 1
Converting date format 4
Date Format 3
Convert Date string to date format 7
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Convert dates stored as text 2

Top