convert text to date
thanks.
"Bob Phillips" wrote:
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
|