Spreadsheet: 144775d1331133900-excel-2007-changing-a-defualt-date-00-00-1900-to-a-blank-clearing-default-dates-070312
Sheet: Raw Data

A | B | C | D | Next A | Next B | uniq
 |  |  | 2011-01-04 08:05:01 |  |  | 20053026Z604785
 |  |  |  |  |  | 20059167Z100912
 |  |  | 2011-01-04 10:18:17 |  |  | 20053026Z604319
 |  |  | 2011-01-04 11:18:04 |  |  | 20053026Z604320
 | 2011-01-04 11:39:08 |  |  |  |  | 20140011397087
 |  |  |  |  |  | 20089153C452481
 |  |  | 2011-01-04 15:20:41 |  |  | 20078006C344806
 |  |  | 2011-01-04 21:11:00 |  |  | 20053026Z604321
 |  |  | 2011-01-04 21:13:43 |  |  | 20053026Z602844
 |  |  | 2011-01-04 21:16:17 |  |  | 20053026Z605214
 |  |  | 2011-01-04 21:21:09 |  |  | 20053026Z604324
 |  |  | 2011-01-04 21:32:05 |  |  | 20053026C429731
 |  |  | 2011-01-04 21:32:43 |  |  | 20053026C429737
2011-01-05 08:00:00 |  |  |  | 2012-01-05 08:00:00 |  | 20080058C430650
2011-01-05 08:00:00 |  |  |  | 2012-01-05 08:00:00 |  | 20080030398373
2011-01-05 08:00:00 |  |  |  | 2012-01-05 08:00:00 |  | 20142239C452495
 |  |  |  |  |  | 22529009C428918
2011-01-05 08:10:45 |  |  |  | 2012-01-05 08:10:45 |  | 20142210C482324
2011-01-05 10:28:32 |  |  |  | 2012-01-05 10:28:32 |  | 20142147C438924
 |  |  |  |  |  | 20080094C447357
 |  | 2011-01-05 13:40:47 |  |  | 2012-01-05 13:40:47 | 20046081C431312
 |  |  |  |  |  | 20026154374140
 |  |  | 2011-01-06 08:00:00 |  |  | 20038007
2011-01-07 07:57:06 |  |  |  | 2012-01-07 07:57:06 |  | 20140034397080
 |  | 2011-01-07 08:00:00 |  |  | 2012-01-07 08:00:00 | 23270029C467404
 |  |  |  |  |  | 20080074343349
2011-01-10 07:53:21 |  |  |  | 2012-01-10 07:53:21 |  | 20080046394267
 |  |  |  |  |  | 22529006C428965
2011-01-10 08:00:00 |  |  |  | 2012-01-10 08:00:00 |  | 20080014343465
2011-01-11 08:00:00 |  |  |  | 2012-01-11 08:00:00 |  | 20080028366391
2011-01-11 08:00:00 |  |  |  | 2012-01-11 08:00:00 |  | 20080062C424758
2011-01-11 08:07:01 |  |  |  | 2012-01-11 08:07:01 |  | 20142210C445539
2011-01-11 16:06:09 |  |  |  | 2012-01-11 16:06:09 |  | 20080020343384
2011-01-12 07:53:20 |  |  |  | 2012-01-12 07:53:20 |  | 47794835Z602423
2011-01-12 07:53:23 |  |  |  | 2012-01-12 07:53:23 |  | 47794835Z602967
2011-01-12 08:00:00 |  |  |  | 2012-01-12 08:00:00 |  | 20142002343347
2011-01-12 08:11:42 |  |  |  | 2012-01-12 08:11:42 |  | 20059167Z100912
2011-01-12 08:29:17 |  |  |  | 2012-01-12 08:29:17 |  | 20142164C444799
2011-01-12 08:56:31 |  |  |  | 2012-01-12 08:56:31 |  | 20097006357061
 | 2011-01-12 08:58:57 |  |  |  |  | 20009062C480637
 | 2011-01-12 11:57:59 |  |  |  |  | 20009062C480657
 |  |  |  |  |  | 23528001
2011-01-12 13:28:04 |  |  |  | 2012-01-12 13:28:04 |  | 20059046Z509783
2011-01-12 14:40:00 |  |  |  | 2012-01-12 14:40:00 |  | 20011026414869
 | 2011-01-13 08:00:00 |  |  |  |  | 20009077C454372
2011-01-13 08:00:00 |  |  |  | 2012-01-13 08:00:00 |  | 20080037326651
 |  |  |  |  |  | 23079004Z605695
 | 2011-01-13 09:00:00 |  |  |  |  | 20084052366392
 |  |  |  |  |  | 44014120Z606131
 |  |  |  |  |  | 20018003C457708
 |  | 2011-01-13 14:00:11 |  |  | 2012-01-13 14:00:11 | 20059124C431293
2011-01-13 14:40:31 |  |  |  | 2012-01-13 14:40:31 |  | 20011016Z509700
2011-01-14 08:00:20 |  |  |  | 2012-01-14 08:00:20 |  | 20080091C430643
 |  | 2011-01-14 09:55:41 |  |  | 2012-01-14 09:55:41 | 20135069414857
 |  |  |  |  |  | 20009055C430648
2011-01-14 14:48:34 |  |  |  | 2012-01-14 14:48:34 |  | 20080039374107
2011-01-17 07:42:01 |  |  |  | 2012-01-17 07:42:01 |  | 20011023414818
 |  |  |  |  |  | 20059105
2011-01-17 08:00:44 |  |  |  | 2012-01-17 08:00:44 |  | 20059166C454399
 |  |  |  |  |  | 20043001
 |  |  |  |  |  | 20097004C435721
 | 2011-01-18 08:51:57 |  |  |  |  | 40015505C448855
 |  |  |  |  |  | 20097004C435721
2011-01-19 08:00:00 |  |  |  | 2012-01-19 08:00:00 |  | 20080026366510
 | 2011-01-19 08:19:33 |  |  |  |  | 40017385C445523
2011-01-20 07:30:37 |  |  |  | 2012-01-20 07:30:37 |  | 20011024414825
 |  |  |  |  |  | 44013605
 |  | 2011-01-20 14:37:15 |  |  | 2012-01-20 14:37:15 | 20059019C431269
 |  | 2011-01-21 08:00:00 |  |  | 2012-01-21 08:00:00 | 20134061C428905
2011-01-21 08:00:00 |  |  |  | 2012-01-21 08:00:00 |  | 20080073370076
2011-01-21 08:00:00 |  |  |  | 2012-01-21 08:00:00 |  | [PHONE]
 |  |  |  |  |  | 20045015
2011-01-24 07:51:52 |  |  |  | 2012-01-24 07:51:52 |  | 20142272C451741
2011-01-24 08:00:00 |  |  |  | 2012-01-24 08:00:00 |  | 20080021343426
 |  |  |  |  |  | 23454001C471748