清空筛选条件
清空筛选条件

replicating a cell vector of dates

2 次查看（过去 30 天）
antonet
antonet 2012-6-21
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 个评论
Ryan
Ryan 2012-6-21
Are you sure that this is Matlab doing it and not Excel?
antonet
antonet 2012-6-21
that 's a good question. I have to wait till tomorrow when i try this to my pc's office.
thanks anyway

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Jan
Jan 2012-6-22
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);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by