replicating a cell vector of dates

1 view (last 30 days)
antonet
antonet on 21 Jun 2012
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 Comments
antonet
antonet on 21 Jun 2012
that 's a good question. I have to wait till tomorrow when i try this to my pc's office.
thanks anyway

Sign in to comment.

Accepted Answer

Jan
Jan on 22 Jun 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);
  1 Comment
antonet
antonet on 22 Jun 2012
You are right. I checked this in my pc's office. thanks

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by