| 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 |
| 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 | |||
Threaded Mode
