importing dates into excel
Show older comments
HI all, I issue the command
A=datestr(datenum({'02/11/08'},'dd/mm/yy')+(0:28:38*28),{'dd/mm/yy'});
but A has size 39 by 8 . I want to be 39 by 1 so as to import A in an excel as a column.
1 Comment
Oleg Komarov
on 23 May 2012
You cannot supply the date format as {'dd/mm/yy'}
Accepted Answer
Oleg Komarov
on 23 May 2012
Use cellstr()
cellstr(datestr(datenum({'02/11/08'},'dd/mm/yy')+(0:28:38*28),'dd/mm/yy'))
More Answers (0)
Categories
Find more on Data Import from MATLAB 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!
