fixing a problem with the date format

1 visualización (últimos 30 días)
Sabbas
Sabbas el 2 de Ag. de 2012
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 comentario
Oleg Komarov
Oleg Komarov el 2 de Ag. de 2012
Cannot reproduce the problem on Win7 64b R2012a.

Iniciar sesión para comentar.

Respuesta aceptada

Sabbas
Sabbas el 2 de Ag. de 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!

Más respuestas (1)

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

Iniciar sesión para comentar.

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by