| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert date from "Fri Aug 22 13:49:20 EDT 2003"
Need to convert a bunch of text files that include dates in the "Fri Aug 22
13:49:20 EDT 2003" format. Have been unable to break them into separate columns during import as the other columns are all tab delimited. Wish to convert this into a standard date/time format. How best to achieve this as I have numerous files to do this with. TIA, ~Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
| Is there a "last saved on date/user" macro/function for Excel 2003 | Excel Discussion (Misc queries) | |||
| convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
Threaded Mode
