replicating a cell vector of dates
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Dear all,
I have the cell vector
jji=
'JAN 2009'
'FEB 2009'
'MAR 2009'
'APR 2009'
'MAY 2009'
'JUN 2009'
'JUL 2009'
'AUG 2009'
'SEP 2009'
'OCT 2009'
'NOV 2009'
'DEC 2009'
'JAN 2010'
'FEB 2010'
'MAR 2010'
'APR 2010'
'MAY 2010'
'JUN 2010'
'JUL 2010'
'AUG 2010'
'SEP 2010'
'OCT 2010'
'NOV 2010'
'DEC 2010'
and I want to replicate this vector 10 times.
So I do the following
B = jji(:,ones(10,1)); B1= B(:);
which works but in the excel file the output for the dates is expressed in numbers (number dates)
Is it possible to fix that so that in the data output file to see 'SEP 2010', 'OCT 2010', 'NOV 2010' instead of their corresponding numbers?
thanks
2 Commenti
Risposta accettata
Jan
il 22 Giu 2012
This problem does not concern Matlab, but the display in Excel. You can select the column and set the display format to "date".
Another method for replication:
B1 = repmat(B, 10, 1);
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Tables in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!