View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scubadiver scubadiver is offline
external usenet poster
 
Posts: 55
Default convert text to date

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