How May I import date/time from Excel?
1 view (last 30 days)
Show older comments
Soli on 26 May 2014
Commented: Mahdi on 26 May 2014
I have a time series in Excel sheet and would like to import it to MATLAB but the date variable becomes scientific numbers like this: 9.37500000000000e-05, 8.82352941176471e-05, 7.50000000000000e-05, 7.14285714285714e-05, I tried "datestr()" function to convert them into "mm/dd/yyyy" format but the output was "12 am" for all dates. How may I transfer date variable to MATLAB and have "mm/dd/yyyy" format?
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!