MATLAB: When using the import tool to import data from an excel file, how to convert the spreadsheet dates to datenumbers

Question

Answer 1

To convert dates from spreadsheets to Date Number add a new rule for converting dates to Date Number. To add this rule:

1) Select “Convert” from drop down list in middle of the import window then Spreadsheets dates to->datenum from next dropdown lists.

2) Click “Import Selection” button this will import the selected data to the workspace in Date Numbers.

Please refer to following link for information on importing spreadsheet data:

http://www.mathworks.com/help/matlab/import_export/select-spreadsheet-data-interactively.html