C

#### c stinz

Working with a file and all my dates and times appear as one long text

string shown below that I would like to convert to date and time

format so that I can manipulate the data anyway I like. Data appears

as follows:

..

cell A1: 10/1/2011 2:20:00 PM

cell A2: 1/18/2011 2:20:00 AM

I have tried many different ways and sometimes it works. The problem

is when the date and month are not 2 digits. As you see the date or

the month can be 1 or 2 digits. How do I convert it so that it works

no matter what..

this works only when the month and date are both 2 digits

=DATE(MID(A1,7,4),MID(A1,4,2),LEFT(A1,2))+RIGHT(A1,10)

Hope someone can help . Thanks