XLS file with a date column, the date column cannot be read correctly with MATLAB 2016a in os x (10.11.5)

I have a Excel file with a date column, the date column can be read correctly with Numbers in os x (10.11.5) . However, when I open the file with 2016a, the date column is change to be 5 consecutive digits, it supposed to be mm/dd/yy. Please advise how to resolve the problem.

REMARK

=================

I open the file with MATLAB 2016a(double click with filename in MATLAB) and I did't call any command in the window.

Please refer the Excel file (the author name for documents, Dr. E.P.Chan) https://github.com/burakbayramli/kod/blob/master/books/Quantitative_Trading_Chan/IGE.xls

Answer 1

[Walter Roberson]

t = readtable('IGE.xls');
t.Date = datetime(t.Date, 'ConvertFrom', 'excel', 'Format', 'MM/dd/yy');

[Nelson Mok]

Dear Walter, this is the final version for your reference. Thank you.

clear;
t = readtable('IGE.xls');
t.Date = datestr(x2mdate(t.Date),'mm/dd/yyyy');
t.Date=datestr(datenum(t.Date, 'mm/dd/yyyy'), 'yyyymmdd');

[Walter Roberson]

You do not need datenum, datestr, or x2mdate() if you have R2014b or later.

t = readtable('IGE.xls');
t.Date = char( datetime(t.Date, 'ConvertFrom', 'excel', 'Format', 'yyyyMMdd') );

[Nelson Mok]

Dear Walter, According to your suggestions, I did the code-fixing. Thank you.