different excel version time convert problem

Hi all

I was using excel 2007 version and Matlab2010 on my windows. I have excel table and for importing time I was using datenum(such as datenum('25/05/1970','dd/mm/yyyy')) function. It was working perfectly.

Now I changed my excel version 2015 and Matlab 2016 working on Mac. Now this excel version understanding my times as 25654, 25754...

How I can convert time?

Thanks!

Answer 1

[Marc Jakobi]

You may have to check the language setting or the formatting of the date on your mac

[davit petraasya]

Thank Marc, yes it seems it was formatting problem.