Solved: date and time score as text

[chungtinhlak]

If i have dates and time in text format stored this way. what's the quickiest way to get it back into the proper format?




2008/11/21 13:26:08
2008/04/01 15:55:55
2008/10/03 17:56:22
2008/01/16 11:37:57
2008/10/01 19:27:13

[Bob Phillips]

If you don't mind separtae cells, you could select the column, Data>Text To Columns, and step through until step 3 and select the Date option.

[chungtinhlak]

thanks xld, after looking through google, i found this method that works best.
have another column
LET X BE THE COLUMN WHERE YOU DATE AND TIME IS STORE

=datevalue(X) + TIMEVALUE(X)

THANKS FOR YOU HELP