Import from Excel - Date not working

Import from Excel - Date not working

I am trying to import data from Excel.  I exported my data from a ZoHo view to make sure I have the correct headings and columns.   When I try to import the same file which I just exported, everything works fine except the Date. 

My Date field is a Date-Time.  It exports to excel as "Apr 07, 2010 23:27:28".  The cell is formatted as " mmm dd,yyyy hh:mm:ss"   When I try to reimport this same exact file back into Zoho creator, the date time field is blank.

I have tried to change the format in excel to almost everything I have found on this forum, like 

mmm dd,yyyy hh:mm:ss

dd mm yyyy hh:mm:ss

mmm dd,yyyy hh:mm:ss

yyyy-mm-dd hh:mm:ss


The date field always comes up blank, while all other fields work perfectly.


Thank you for any help.