convert text to date

[scubadiver]

I have imported records into Excel and I get date info as text format

02-07-2007 11:14:00.0
02-07-2007 15:33:00.0
03-07-2007 11:16:00.0
29-06-2007 16:02:00.0
02-07-2007 09:54:00.0

How can I convert this to a general date/time format

Cheers

 

[Bob Phillips]

In Data>Text To Columns, select Delimited, and make sure you uncheck space,
then on the Next tab, select the date option, then Finish

You will probably need to reformat the column.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[MartinW]

Hi scubadiver,

Did you perhaps lose your thread from a couple of days ago.
Here is a link to it.

http://www.microsoft.com/office/com...&p=1&tid=0a4d588a-522e-4a06-9c5d-a41eed94cf3f

HTH
Martin

 

[scubadiver]

thanks.

In Data>Text To Columns, select Delimited, and make sure you uncheck space,
then on the Next tab, select the date option, then Finish

You will probably need to reformat the column.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)