Spreadsheet: 144779d1331134244-excel-2007-changing-a-defualt-date-00-00-1900-to-a-blank-0329
Sheet: Output

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