replicating dates and inporting them in an excel file

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?

Answer 1

[bym]

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

[ektor]

Thanks. It works. I was wondering if there is another way to fix it so as not to have to change the format of the excel cell to 'date'. I mean if it is possible to do that correction directly within matlab without having to do the modifications within excel.

Thanks again.