importing data with dates from excel

How to import data from excel spread sheet and preserve date format and time of day format

Answer 1

[Azzi Abdelmalek]

[~,~,data]=xlsread('yourfile')

[Azzi Abdelmalek]

Robert commented

Thank you.Unfortunately does not work. If I use 'import data' facility, the table is imported but under date column the title 'date' is replaced by NaN and the actual dates are converted to [Type:Number,value:nnnnn.0]. However, the other information in the table is imported and tabulated correctly.