convert dd/mm/yyyy ro serial

I got some data in excel with date in the formate of dd/mm/yyyy

d = xlsread ('excel.xlsx','D9:D7808')

then I try to do a datenum, but it doesn't work becuase the data is in dd/mm/yyyy

so How could I convert dd/mm/yyyy to yyyy-mm-dd or convert date into serial in some other ways

Thanks

[Rik]

Is the data stored as a date in the excel file? Or as text?

[Image Analyst]

Here's another chance to read the posting guidelines you skipped over when posting:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

After you remember to upload your workbook, we'll be able to help more.

Answer 1

[Walter Roberson]

d = readmatrix('excel.xlsx', 'D9:D7808');
d.Format = 'yyyy-MM-dd';

And if you need to,

cellstr(d)