Multi-Delimited file

I have data in xls files and one of the rows looks like this: 1/1/09 0:21 The first have represents date and the second have represents time. when imported using xlsread is get a long number which means nothing I need the date and the time. Can some one help me please.

[Paulo Silva]

post the code you are using and someone might tell you what your should improve or change.

[faisal Mahmood]

for i = 1:numberoffiles

A = 'Data';

str = sprintf('%d',i);

varname = [A,str];

filename = listing(i,:).name;

[ndata, text, alldata]= xlsread(filename);

end

Answer 1

[Walter Roberson]

datestr() that long number. But be sure to cross-check the result, as excel's time base is different than Matlab's. There is a relatively simple time conversion if needed. The offsets are documented here

[faisal Mahmood]

what about if its in the middle of the file. Like it row number T.

[Walter Roberson]

Then datestr(ndata(T,C)) where C is the column number.