PDA

View Full Version : date format and filtering



chungtinhlak
01-13-2009, 06:01 PM
Hello,

i have dates that looks like this (below): i have two question, is there a way that I can use auto filter to filter out all the december of 08? second question, currently, it's in text format, is there a way to get it back to date and time format. I have tried datevalue but that will lose the time.

thank you for you help.

2008/12/12 17:52:52
2008/12/12 16:49:52
2008/12/12 16:46:34
2008/12/12 16:43:35
2008/12/12 16:41:05
2008/12/12 16:38:26
2008/12/12 16:36:03
2008/12/12 16:32:55
2008/12/12 16:10:47
2008/12/12 16:03:40
2008/12/12 15:59:42
2008/12/12 15:56:15
2008/12/12 15:53:44
2008/12/12 15:28:08
2008/12/12 15:25:31
2008/12/11 20:50:31
2008/12/11 18:37:01
2008/12/11 17:18:21
2008/12/10 22:19:40
2008/12/10 22:16:55
2008/12/10 21:22:15
2008/12/10 21:18:24
2008/12/10 21:15:39
2008/12/10 21:09:07
2008/12/10 21:04:54
2008/12/10 20:59:40
2008/12/10 20:56:33
2008/12/10 20:53:45
2008/12/10 18:20:09
2008/12/09 23:39:24
2008/12/09 22:38:01
2008/12/09 22:24:56
2008/12/09 21:30:58
2008/12/09 21:15:09
2008/12/09 21:10:25
2008/12/09 21:05:28
2008/12/09 21:01:22
2008/12/09 20:16:11
2008/12/09 20:12:10
2008/12/09 20:02:38
2008/12/09 18:11:52
2008/12/09 18:08:00
2008/12/09 18:01:14
2008/12/09 17:59:41
2008/12/09 17:34:26
2008/12/09 17:30:43
2008/12/09 15:48:27
2008/12/09 15:33:27
2008/12/09 15:30:40
2008/12/09 15:27:02
2008/12/09 15:23:53