MATLAB: Add multiple timestamps in the excel file first column timestamp Hi I am using xlswrite to add string of timestamps to the first column of excel file but it shows me #######. How to correct this? I would be very grateful for your help. Regards Best Answer ##### - Sometimes referred to as “Railroad tracks”, this error can be caused by several conditions:A number in a cell is too wide for the cell to display it.The formula in the cell produces a result that is too wide for the cell.There is a negative number in the cell that has been formatted for dates or times. Dates and times in Excel must be positive values.Solution:Widen the column containing the problem cell.Change the format of the problem cell to something other than a date/time format.Correct the negative number in a date/time formatted cell. Related SolutionsMATLAB: Time stamp using xlswrite clox=cellstr(datestr(now)) xlswrite('d:\repeati.xlsx',clox,'E5:E5'); MATLAB: How to import date time format from excel Use xlsread function[num,text,both]=xlsread('yourfile.xlsx') Related QuestionHow to use DATENUM on a cell array of dates (specified without time information) with each date in a different formatVector of decimal dayExcel Date Format to Matlab Number Array
Best Answer