import data from excel into matlab gives false date

Question

Locks 2013-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/71510-import-data-from-excel-into-matlab-gives-false-date

hi, I have importet data from excel into matlab using the following code:

filename = 'vola_regimes.xlsx';
sheet = 1;
xlRange_d = 'C4:C132';
xlRange_sp='D4:D132';
xlRange_dV = 'H4:H132';
xlRange_VIX='I4:I132';
date_SP = xlsread(filename, sheet, xlRange_d)
SP = xlsread(filename, sheet, xlRange_sp)
date_VIX = xlsread(filename, sheet, xlRange_dV)
VIX = xlsread(filename, sheet, xlRange_VIX)

That is working perfectly, but the problem is that range C4:C132 and H4:H132 are both dates. the import fuction didn't work ant therefore I changed the format in excel to general instead of date. then I am able to imporat the data, but from what I can see when I use the datestr function, matlab is not recognizing the data correctly and instead of 05.08.2002 it gives me 06-Aug-0102

Is there a way to change that?