Reading time and dates from Excel

1 view (last 30 days)
fengwei jin
fengwei jin on 7 Feb 2016
Answered: Azzi Abdelmalek on 7 Feb 2016
Hey guys,
I have a problem using the xlsread function, in my spreadsheet,my dates are given in the following format:
So i used [numericData, stringData, allData] = xlsread(dataSource); But all the dates are in the string data is there a way that i can get those dates into the numericData?

Sign in to answer this question.

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 7 Feb 2016
Use datenum function

More Answers (0)

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!