Hi, I'm using xlsread to read the content of an .xlsx file
[data,text]=xlsread('MSCIandFX.xlsx','MSCIPI');
it sort of works but it's treating all the dates as numbers. I tried the same on a windows machine and the dates where treated as text and thus appeared under the data variable.
Can someone give their interpretation of what's going on and what's the best way to handle this situation?
edit: for example the date "12/31/1987" is imported in matlab as 32142 which is the same value I see on OpenOffice when converting that same date to text format in the xlsx file. I am attaching the file I'm using
Thanks
Best Answer