Add multiple timestamps in the excel file first column

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

Answer 1

[Muhammad Usman Saleem]

##### - 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.

[Muhammad Usman Saleem]

@Zargham Ali if you have resolved your problem then please accept my answer.

[Zargham Ali]

Thanks a lot for reply. I had to widen the columns :).

[Zargham Ali]

%start time stime=datenum(2012,1,2,0,0,0) %end time etime=datenum(2012,1,2,23,00,00) %length of time step (1D, 3min in this case) delta=datenum(0,0,0,1,0,0) %ymdhms for nw=stime:delta:etime clox=cellstr(datestr(nw))

end xlswrite('MERRA.xlsx',clox,'A2:A24');

i am trying this code but it always shows me the end time that is 2012 1 2 23:00 in excel file but in command window of MATLAB the output increases the time hourly from 1 till 23

[Muhammad Usman Saleem]

please format your codes and give brief description