writing date on an excel sheet

Hi folk,

Got a question about writing date on an excel sheet. I am using the following codes:

DATE=datestr(now);

xlswrite('test.xls', DATE, 'A1')

The problem is that it separates each number and letter and put them in separate cells. I want the whole date in one cell like 'A1' but it appears from 'A1' to 'T1'

I appreciate your help. Thank you.

S:-)

[Prieni]

Just came across the problem to export date/time to an Excel sheet. If you do this:

DATE = now - datenum(1899,12,30,0,0,0);

xlswrite('test.xls',DATE)

you get a number in your Excel sheet that, if you change formatting to date, shows the current date. It also includes the current time which you can see when you select that date.

Answer 1

[Oleg Komarov]

xlswrite('test.xls', {datestr(now)})

[S]

Thank you very much Oleg:)

[Rageeni sah]

Hello, Is this code work for you??