| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert text to date
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert text to date
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Text to DATE | Excel Discussion (Misc queries) | |||
| Convert date to text | Excel Discussion (Misc queries) | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| convert date to text | Excel Discussion (Misc queries) | |||
| Convert a Date to Text? | Excel Worksheet Functions | |||
Linear Mode
