fixing a problem with the date format
1 view (last 30 days)
Show older comments
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
1 Comment
Accepted Answer
More Answers (1)
Andrei Bobrov
on 2 Aug 2012
xlswrite('yournamefile.xlsx',cellstr(datestr(datevec(A,'mm/yy'),'mm/yyyy')))
1 Comment
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!