问下版内高手，这个时间序列怎么设置正确啊？

2006-2-9 01:54:01
2006-2-9 01:55:48
2006-2-9 1:55
2006-2-9 01:57:29
2006-2-9 1:57
2006-2-9 01:59:25
2006-2-9 02:01:39
2006-2-9 2:01
2007-2-9 02:14:08
2006-2-9 02:03:33
2006-2-9 02:05:38
2006-2-9 2:03
2006-2-9 02:06:48
2007-2-9 02:24:13
2006-2-9 02:09:31
2006-2-9 02:11:33
2006-2-9 02:12:38
2006-2-9 02:14:36
2007-2-9 02:31:38
2006-2-9 02:16:30
2007-2-9 02:35:21
2006-2-9 02:18:27
2006-2-9 02:22:00
2006-2-9 02:24:57
2006-2-9 02:26:21
2007-2-9 02:39:33
2006-2-9 02:27:37
2006-2-9 02:28:56
2007-2-9 02:46:59
2006-2-9 02:31:33
2006-2-9 02:33:27
2006-2-9 02:34:35
2007-2-9 02:51:35
2006-2-9 02:35:52
2007-2-9 02:55:49
2006-2-9 02:39:53
2006-2-9 02:41:04
2006-2-9 02:42:58
2006-2-9 02:44:11
2006-2-9 02:45:21
2007-2-9 02:59:21
2006-2-9 02:46:49
2006-2-9 02:48:05
2006-2-9 02:50:59
2006-2-9 02:52:28
2007-2-9 03:06:41
2006-2-9 02:54:15
2006-2-9 02:56:13
2006-2-9 02:57:22
2007-2-9 03:14:02
2006-2-9 02:59:28
2006-2-9 2:08
2006-2-9 03:00:22
2007-2-9 03:19:09
2006-2-9 3:00
2006-2-9 03:01:36
2006-2-9 03:06:20
2007-2-9 03:23:43
2006-2-9 3:04
2006-2-9 03:08:05
2006-2-9 03:10:28
2006-2-9 03:12:01
2006-2-9 03:13:07
2006-2-9 3:09
2006-2-9 03:14:12
2006-2-9 3:14
2006-2-9 03:17:16
2006-2-9 03:19:12
2006-2-9 3:17
2006-2-9 03:20:37
2006-2-9 3:20
2006-2-9 03:23:00
2007-2-9 03:35:14
2006-2-9 3:23
2006-2-9 03:24:05
2006-2-9 03:25:43
2006-2-9 3:24
2006-2-9 03:26:50
2007-2-9 03:44:13
2006-2-9 03:28:23
2006-2-9 03:31:10
2006-2-9 03:32:37
2007-2-9 03:50:06
2007-2-9 04:40:24
2007-2-9 04:44:05
2007-2-9 04:48:29
2007-2-9 04:53:21
2007-2-9 04:58:38
2007-2-9 05:09:31
2007-2-9 05:13:25
2006-2-9 05:07:10
2006-2-9 5:13
2006-2-9 5:15
2006-2-9 5:17
2006-2-9 05:14:27
2006-2-9 5:19
2006-2-9 05:21:16
2006-2-9 05:26:32
2007-2-9 05:21:01
2006-2-9 5:35
2006-2-9 05:35:14
2006-2-9 05:39:22
2006-2-9 5:40
2006-2-9 5:43
2006-2-9 05:41:58
2006-2-9 05:47:34
2006-2-9 05:50:06
2006-2-9 5:46
2006-2-9 05:51:50
2006-2-9 05:58:19
2006-2-9 06:03:33
2006-2-9 06:07:16
2006-2-9 06:11:12
2006-2-9 06:13:52
2006-2-9 06:15:47
2006-2-9 06:18:04
2006-2-9 06:19:26
2006-2-9 06:22:02
2006-2-9 06:28:19
2006-2-9 06:29:41
2006-2-9 06:33:11
2006-2-9 06:34:42
2006-2-9 06:37:01
2006-2-9 06:40:44
2006-2-9 5:51
2006-2-9 6:43
2006-2-9 6:52
2006-2-9 06:43:12
2006-2-9 07:01:53
2006-2-9 6:56
2006-2-9 07:04:10
2006-2-9 07:08:48
2006-2-9 07:10:20
2006-2-9 07:12:38
2006-2-9 7:07
2006-2-9 07:14:45
2006-2-9 07:18:29
2006-2-9 07:20:21
2006-2-9 07:27:10
2006-2-9 07:29:02
2006-2-9 07:32:35
2006-2-9 07:34:04
2006-2-9 07:38:14
2006-2-9 07:40:13
2006-2-9 07:42:29
2006-2-9 07:46:23
2006-2-9 07:48:03
2006-2-9 07:50:03
2006-2-9 07:51:26
2006-2-9 07:53:05
2006-2-9 07:55:19
2006-2-9 07:56:23
2006-2-9 08:02:11
2006-2-9 08:03:10
2006-2-9 08:05:17
2006-2-9 08:06:16
2006-2-9 08:01:04
2006-2-9 08:07:07
2006-2-9 08:07:40
2006-2-9 08:08:11
2006-2-9 08:09:19
2006-2-9 08:10:15
2006-2-9 08:11:04
2006-2-9 08:12:38
2006-2-9 08:12:34
2006-2-9 08:15:16
2006-2-9 08:14:33
2006-2-9 08:16:41
2006-2-9 08:17:23
2006-2-9 08:19:25
2006-2-9 08:19:31
2006-2-9 08:21:05
2006-2-9 08:20:50
2006-2-9 08:22:56
2006-2-9 08:23:26
2006-2-9 08:24:40
2006-2-9 08:24:21
2006-2-9 08:26:30
2006-2-9 08:29:09
2006-2-9 08:28:54
2006-2-9 08:31:09
2006-2-9 08:32:10
2006-2-9 08:33:34
2006-2-9 08:34:42
2006-2-9 08:38:41
2006-2-9 08:40:13
2006-2-9 08:41:42
2006-2-9 08:31:17
2006-2-9 08:42:45
2006-2-9 08:44:40
2006-2-9 08:47:16
2006-2-9 08:44:34
2006-2-9 08:51:23
2006-2-9 08:54:56
2006-2-9 08:54:00
2006-2-9 08:55:51
2006-2-9 08:55:50
2006-2-9 08:57:05
2006-2-9 08:59:53
2006-2-9 09:03:17
2006-2-9 08:57:58
2006-2-9 09:04:43
2006-2-9 09:05:59
2006-2-9 09:21:08
2006-2-9 09:23:28
2006-2-9 09:25:46
2006-2-9 09:06:02
2006-2-9 09:27:01
2006-2-9 09:29:43
2006-2-9 09:29:35
2006-2-9 09:31:19
2006-2-9 09:33:02
2006-2-9 09:32:35
2006-2-9 09:34:14
2006-2-9 09:36:21
2006-2-9 09:35:01
2006-2-9 09:37:44
2006-2-9 09:38:52
2006-2-9 09:37:43
2006-2-9 09:42:09
2006-2-9 09:43:50
2006-2-9 09:45:49
2006-2-9 09:47:35
2006-2-9 09:50:37
2006-2-9 09:52:14
2006-2-9 09:57:51
2006-2-9 10:00:03
2006-2-10 00:16:12
2006-2-10 00:19:33
2006-2-10 00:21:07
2006-2-10 00:22:11
2006-2-10 00:19:54
2006-2-10 00:27:34
2006-2-10 00:24:33
2006-2-10 00:29:05
2006-2-10 00:30:09
2006-2-10 00:31:30
2006-2-10 00:32:08
2006-2-10 00:33:28
2006-2-10 00:34:23
2006-2-10 00:36:02
2006-2-10 00:35:57
2006-2-10 00:37:07
2006-2-10 00:38:24
2006-2-10 00:43:10
2006-2-10 00:43:44
2006-2-10 00:44:55
2006-2-10 00:46:35
2006-2-10 00:49:48
2006-2-10 00:45:34
2006-2-10 00:51:03
2006-2-10 00:52:32
2006-2-10 00:53:25
2006-2-10 00:51:48
2006-2-10 00:51:57
2006-2-10 00:54:33
2006-2-10 00:55:50
2006-2-10 00:56:48
2006-2-10 00:54:56
2006-2-10 00:55:34
2006-2-10 00:57:53
2006-2-10 00:58:22
2006-2-10 00:58:46
2006-2-10 00:58:59
2006-2-10 00:59:59
2006-2-10 00:59:29
2006-2-10 00:59:55
2006-2-10 01:00:57
2006-2-10 01:00:55
2006-2-10 01:01:35
2006-2-10 01:02:49
2006-2-10 01:03:37
2006-2-10 01:02:17
2006-2-10 01:04:28
2006-2-10 01:05:36
2006-2-10 01:05:29
2006-2-10 01:04:54
2006-2-10 01:06:29
2006-2-10 01:07:12
2006-2-10 01:07:48
2006-2-10 01:09:04
2006-2-10 01:09:50
2006-2-10 01:10:13
2006-2-10 01:10:51
2006-2-10 01:12:09
2006-2-10 01:12:38
2006-2-10 01:12:58
2006-2-10 01:14:41
2006-2-10 01:13:31
2006-2-10 01:14:41
2006-2-10 01:15:47
2006-2-10 01:15:52
2006-2-10 01:15:43
2006-2-10 01:16:54
2006-2-10 01:17:28
2006-2-10 01:18:21
2006-2-10 01:17:41
2006-2-10 01:19:52
2006-2-10 01:21:12
2006-2-10 01:21:49
2006-2-10 01:21:28
2006-2-10 01:23:03
2006-2-10 01:18:39
2006-2-10 01:23:53
2006-2-10 01:23:41
2006-2-10 01:24:44
2006-2-10 01:26:53
2006-2-10 01:27:05
2006-2-10 01:28:01
2006-2-10 01:29:01
2006-2-10 01:29:14
2006-2-10 01:29:58
2006-2-10 01:31:01
2006-2-10 01:32:50
2006-2-10 01:30:08
2006-2-10 01:34:39
2006-2-10 01:33:57
2006-2-10 01:36:08
2006-2-10 01:36:03
2006-2-10 01:37:20
2006-2-10 01:39:00
2006-2-10 01:39:04
2006-2-10 01:40:07
2006-2-10 01:41:03
2006-2-10 01:41:59
2006-2-10 01:41:42
2006-2-10 01:43:04
2006-2-10 01:43:22
2006-2-10 01:44:18
2006-2-10 01:45:10

先将数据以空格进行分列，然后选择这个三列进行排序

hw8606 发表于 2012-6-7 15:57
先将数据以空格进行分列，然后选择这个三列进行排序

麻烦您告诉到底咋做啊

数据-分列-分割符号-选择空格，然后目标区域选择在数据旁边的列，点击完成。然后再选择这三列，数据-排序

不好意思呀  我以为你问的是excel呢 献丑了

hw8606 发表于 2012-6-7 17:40
不好意思呀  我以为你问的是excel呢 献丑了

没得关系！