Issue regarding custom fields its very urgent please help....

Issue regarding custom fields its very urgent please help....

Hello

 We came across a problem while we were importing our contacts from excel file. In our excel file we have a field called Create Date that holds a value having date & time(e.g. 5/1/2009  10:16:20 AM). For this we created a custom field in zoho of type Text. But when we import our file the field in zoho show only date(e.g. 5/1/2009) & do not show time in the respective field. We have tried using DateTime type for the same field but the result was same. Its very urgent for us please suggest the solution for our problem as earliest as you can.

Thanks