Excel doesn't recognize some dates/times but recognizes others -

i generating list database , want copy-paste in excel. using iso format date , time values excel recognizes , doesn't recognize others. here example:

2006-10-17 18:13:47.333 -> date/time 2006-10-17 18:18:53.293 -> date/time 2006-10-17 18:51:52.013 -> text? 2006-10-19 15:13:34.923 -> date/time 2006-10-19 15:24:13.023 -> text? 2006-10-19 16:54:07.817 -> date/time 2006-10-19 17:11:21.203 -> date/time 2006-10-19 18:39:59.080 -> text? 

i cannot find logical difference between values not recognized , ones recognized, maybe except first digit in milliseconds 0. ideas?

i don't have clue why happens said when milliseconds start 0 excel fails recognize date. can enforce excel see data inside column date this:

• select column. under data tab select text columns
• select delimited , hit next
• set delimiters hit next
• finally choose date , choose of date formats