convert dd/mm/yyyy ro serial
1 回表示 (過去 30 日間)
古いコメントを表示
I got some data in excel with date in the formate of dd/mm/yyyy
d = xlsread ('excel.xlsx','D9:D7808')
then I try to do a datenum, but it doesn't work becuase the data is in dd/mm/yyyy
so How could I convert dd/mm/yyyy to yyyy-mm-dd or convert date into serial in some other ways
Thanks
2 件のコメント
Image Analyst
2021 年 1 月 18 日
Here's another chance to read the posting guidelines you skipped over when posting:
After you remember to upload your workbook, we'll be able to help more.
回答 (1 件)
Walter Roberson
2021 年 1 月 18 日
d = readmatrix('excel.xlsx', 'D9:D7808');
d.Format = 'yyyy-MM-dd';
And if you need to,
cellstr(d)
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Time Series Objects についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!