MATLAB: Replicating dates and inporting them in an excel file

replicating dates

HI all,
I want to replicate the dates '02/11/2008' '30/11/2008' so at to have
 02/11/2008
30/11/2008
02/11/2008
'30/11/2008
So the repetition is every two elements. I apply the following code" dd=[{'02/11/2008' '30/11/2008'} ]';
B = dd(:,ones(4,1));
 ss= B(:);
which seems to work but when i try to extract the variable ss in an excel file, then the output of the excel file is
39489
30/11/2008
39489
30/11/2008 39489
30/11/2008
39489
30/11/2008
39489
30/11/2008
Is there anything I can do to fix this problem?

Best Answer

change the format of the excel cell to 'date'. You can verify by entering formula in a cell =datevalue("2/11/2008") and the result is 39489
Related Question