Spreadsheet: 193696d1352917889-dates-formatted-as-text-excel-forum-problem
Sheet: Users

"Date" is just text |  |  | Formated as date
Date | Value |  | Date | Value
2012/11/13-07:00 | 1 |  | 2012-11-08 07:00:00 | a
2012/11/13-07:01 | 2 |  | 2012-11-08 07:01:00 | b
2012/11/13-07:02 | 3 |  | 2012-11-08 07:01:59.995000 | a
2012/11/13-07:03 | 4 |  | 2012-11-08 07:02:59.995000 | b
2012/11/13-07:04 | 5 |  | 2012-11-08 07:03:59.995000 | a
2012/11/13-07:05 | 6 |  | 2012-11-08 07:04:59.995000 | b
2012/11/13-07:06 | 7 |  | 2012-11-08 07:05:59.995000 | a
2012/11/13-07:07 | 8 |  | 2012-11-08 07:06:59.995000 | b
2012/11/13-07:08 | 9 |  | 2012-11-08 07:07:59.995000 | a
2012/11/13-07:09 | 10 |  | 2012-11-08 07:08:59.995000 | b
2012/11/13-07:10 | 11 |  | 2012-11-08 07:09:59.995000 | a
2012/11/13-07:11 | 12 |  | 2012-11-08 07:10:59.995000 | b
2012/11/13-07:12 | 13 |  | 2012-11-08 07:11:59.995000 | a
2012/11/13-07:13 | 14 |  | 2012-11-08 07:12:59.995000 | b
2012/11/13-07:14 | 15 |  | 2012-11-08 07:13:59.995000 | a
2012/11/13-07:15 | 16 |  | 2012-11-08 07:14:59.995000 | b
2012/11/13-07:16 | 17 |  | 2012-11-08 07:15:59.995000 | a
2012/11/13-07:17 | 18 |  | 2012-11-08 07:16:59.995000 | b
2012/11/13-07:18 | 19 |  | 2012-11-08 07:17:59.995000 | a
2012/11/13-07:19 | 20 |  | 2012-11-08 07:18:59.995000 | b
2012/11/13-07:20 | 21 |  | 2012-11-08 07:19:59.995000 | a
2012/11/13-07:21 | 22 |  | 2012-11-08 07:20:59.995000 | b
2012/11/13-07:22 | 23 |  | 2012-11-08 07:21:59.995000 | a
2012/11/13-07:23 | 24 |  | 2012-11-08 07:22:59.995000 | b
2012/11/13-07:24 | 25 |  | 2012-11-08 07:23:59.995000 | a
2012/11/13-07:25 | 26 |  | 2012-11-08 07:24:59.995000 | b
2012/11/13-07:26 | 27 |  | 2012-11-08 07:25:59.995000 | a
2012/11/13-07:27 | 28 |  | 2012-11-08 07:26:59.995000 | b
2012/11/13-07:28 | 29 |  | 2012-11-08 07:27:59.995000 | a
2012/11/13-07:29 | 30 |  | 2012-11-08 07:28:59.995000 | b
2012/11/13-07:30 | 31 |  | 2012-11-08 07:29:59.995000 | a
2012/11/13-07:31 | 32 |  | 2012-11-08 07:30:59.995000 | b
2012/11/13-07:32 | 33 |  | 2012-11-08 07:31:59.995000 | a
2012/11/13-07:33 | 34 |  | 2012-11-08 07:32:59.995000 | b
2012/11/13-07:34 | 35 |  | 2012-11-08 07:33:59.995000 | a
2012/11/13-07:35 | 36 |  | 2012-11-08 07:34:59.995000 | b
2012/11/13-07:36 | 37 |  | 2012-11-08 07:35:59.995000 | a
2012/11/13-07:37 | 38 |  | 2012-11-08 07:36:59.995000 | b
2012/11/13-07:38 | 39 |  | 2012-11-08 07:37:59.995000 | a
2012/11/13-07:39 | 40 |  | 2012-11-08 07:38:59.995000 | b
2012/11/13-07:40 | 41 |  | 2012-11-08 07:39:59.995000 | a
2012/11/13-07:41 | 42 |  | 2012-11-08 07:40:59.995000 | b
2012/11/13-07:42 | 43 |  | 2012-11-08 07:41:59.995000 | a
2012/11/13-07:43 | 44 |  | 2012-11-08 07:42:59.995000 | b
2012/11/13-07:44 | 45 |  | 2012-11-08 07:43:59.995000 | a
2012/11/13-07:45 | 46 |  | 2012-11-08 07:44:59.995000 | b
2012/11/13-07:46 | 47 |  | 2012-11-08 07:45:59.995000 | a
2012/11/13-07:47 | 48 |  | 2012-11-08 07:46:59.995000 | b
2012/11/13-07:48 | 49 |  | 2012-11-08 07:47:59.995000 | a
2012/11/13-07:49 | 50 |  | 2012-11-08 07:48:59.995000 | b
2012/11/13-07:50 | 51 |  | 2012-11-08 07:49:59.995000 | a
2012/11/13-07:51 | 52 |  | 2012-11-08 07:50:59.995000 | b
2012/11/13-07:52 | 53 |  | 2012-11-08 07:51:59.995000 | a
2012/11/13-07:53 | 54 |  | 2012-11-08 07:52:59.995000 | b
2012/11/13-07:54 | 55 |  | 2012-11-08 07:53:59.995000 | a
2012/11/13-07:55 | 56 |  | 2012-11-08 07:54:59.995000 | b
2012/11/13-07:56 | 57 |  | 2012-11-08 07:55:59.995000 | a
2012/11/13-07:57 | 58 |  | 2012-11-08 07:56:59.995000 | b
2012/11/13-07:58 | 59 |  | 2012-11-08 07:57:59.995000 | a
2012/11/13-07:59 | 60 |  | 2012-11-08 07:58:59.995000 | b
2012/11/13-07:60 | 60 |  | 2012-11-08 07:59:59.995000 | a