replicating dates and inporting them in an excel file
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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?
0 commentaires
Réponse acceptée
bym
le 18 Mai 2012
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
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!