how do I format this date "8:32:44 Aug 03 2009 " to work in excel

how do I format this date "8:32:44 Aug 03 2009 " to work in excel I have a date in the format "hh:mm:ss MMM dd yyyy" in a comma delimited text file. I would like to reformat into a workable date for use in excel...how do I do that?
Asked by: Guest \| Views: 255

Total answers/comments: 1

Comments display order:

bert [Entry]

"You can use the following function or a corresponding macro, based on the following algorithm :

Create the ""date"" using datevalue() function. The input to this would be a string you create from the original format, by keeping only the date portion.

Create the ""time"" using timevalue()

Add datevalue + timevalue to get the final value."