fixing a problem with the date format

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 commentaire

Oleg Komarov
Oleg Komarov le 2 Août 2012
Cannot reproduce the problem on Win7 64b R2012a.

Connectez-vous pour commenter.

 Réponse acceptée

Sabbas
Sabbas le 2 Août 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!

Plus de réponses (1)

Andrei Bobrov
Andrei Bobrov le 2 Août 2012
xlswrite('yournamefile.xlsx',cellstr(datestr(datevec(A,'mm/yy'),'mm/yyyy')))

1 commentaire

Oleg Komarov
Oleg Komarov le 2 Août 2012
@Sabbas: you provided A not output. What is output?

Connectez-vous pour commenter.

Catégories

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by