Home » Questions » Computers [ Ask a new question ]

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: 56
Total answers/comments: 1
Guest [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."