fixing a problem with the date format
Afficher commentaires plus anciens
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
le 2 Août 2012
Cannot reproduce the problem on Win7 64b R2012a.
Réponse acceptée
Plus de réponses (1)
Andrei Bobrov
le 2 Août 2012
xlswrite('yournamefile.xlsx',cellstr(datestr(datevec(A,'mm/yy'),'mm/yyyy')))
1 commentaire
Oleg Komarov
le 2 Août 2012
@Sabbas: you provided A not output. What is output?
Catégories
En savoir plus sur Dates and Time dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!