Problem with date fotmat from excel to Matlab

1 view (last 30 days)
I'm working with a series of data imported to matlab from excel using the function xlsread. The data time format in excel is in dd/mm/yyyy HH:MM and I have alrady changed the format in the column of that parameter in the table that I'm using, so now the format says "Personalized". But when I open the same table in MatLab appears a number. I want to use the same format or change it to yyyy-mm-dd HH:MM but when I use the function datestr to change the number to a string, the dates are not the same (do not match with the excel ones) And when I use the syntax datestr(_, formatOut) and using the format I want, a error message appears. How can I do to fix my code or to be able to use the format I want.

Answers (0)

Community Treasure Hunt

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

Start Hunting!