Gizmo do not understand that for if cell is formatted the answer becomes 13701.17275

your quotes are wrong ... use "1/1/70" and not "1"/1/70



^^ see my formula and where the quotes are

That was the fix for now get

1183780091 7/7/07 3:48 AM
1183782164 7/7/07 4:22 AM
1183782270 7/7/07 4:24 AM
1183790397 7/7/07 6:39 AM
1183800199 7/7/07 9:23 AM
1183801869 7/7/07 9:51 AM
1183802583 7/7/07 10:03 AM
1183804040 7/7/07 10:27 AM
1183806865 7/7/07 11:14 AM
1183808433 7/7/07 11:40 AM

Not sure how excel did that as I pasted your's directly in
maybe when a format was done excel assumed something ?
In any case thanks that what I needed