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/comm...d-a41eed94cf3f

HTH
Martin

"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