fixing a problem with the date format

1 view (last 30 days)
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

Accepted Answer

Sabbas
Sabbas on 2 Aug 2012
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!

More Answers (1)

Andrei Bobrov
Andrei Bobrov on 2 Aug 2012
xlswrite('yournamefile.xlsx',cellstr(datestr(datevec(A,'mm/yy'),'mm/yyyy')))
  1 Comment
Oleg Komarov
Oleg Komarov on 2 Aug 2012
@Sabbas: you provided A not output. What is output?

Sign in to comment.

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!