fixing a problem with the date format

2012 8 2
2 个回答
回答已采纳
5 次查看（30 天）

0 个投票

Dear all,
I have
Inside my code I construct the vector A={
'01/11'
'02/11'
'03/11'
'04/11'
'05/11'
'06/11'
'07/11'
'08/11'
'09/11'
'10/11'
'11/08'
'12/08'
'01/09'
'02/09'
'03/09'
};
But when I save the output into an excel and then open it the format of the dates is wrong and irrelevent.
Is there a way to fix it within Matlab?
thanks

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

 采纳的回答

Sabbas
Sabbas 2012-8-2

0 个投票

I found the solution
Before saving my results I just try
Anew=cellstr(datestr(datenum(A,'mm/yy'),' mm/yyyy'));
then I write my final output into excel and when I open it, the date structure is ok
thank you guys both!

更多回答（1 个）

Andrei Bobrov
Andrei Bobrov 2012-8-2

0 个投票

xlswrite('yournamefile.xlsx',cellstr(datestr(datevec(A,'mm/yy'),'mm/yyyy')))

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by