In DataText 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)



"scubadiver" wrote in message
...
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