<pre>

Path: news.mathworks.com!newsfeed-00.mathworks.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!r15g2000prh.googlegroups.com!not-for-mail
From: Rosy &lt;egrosa941@gmail.com&gt;
Newsgroups: comp.soft-sys.matlab
Subject: Write date in excel
Date: Tue, 4 Nov 2008 16:23:08 -0800 (PST)
Organization: http://groups.google.com
Lines: 39
Message-ID: &lt;a3aebc93-c3b0-408a-9533-b11361f006ac@r15g2000prh.googlegroups.com&gt;
NNTP-Posting-Host: 216.100.254.144
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1225844588 20429 127.0.0.1 (5 Nov 2008 00:23:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 5 Nov 2008 00:23:08 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r15g2000prh.googlegroups.com; posting-host=216.100.254.144; 
	posting-account=g-qKLgoAAAAjz75lsmhFH2cQsUWc1MHj
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) 
	Gecko/2008092417 Firefox/3.0.3,gzip(gfe),gzip(gfe)
Xref: news.mathworks.com comp.soft-sys.matlab:498968


Hello

I am writing to ask a question on writing date in excel.

What I am trying to do is to write date converted from date number in
excel.
For example,
A = [730238
730239
730240
730241
730242
730243
730244
730245
730246
730247];

Date = datestr(A);
xlswrite(xlsfilename, Date);

However, the dates were not written in a cell but as follows

2	8	/	0	4	/	9	9
2	9	/	0	4	/	9	9
3	0	/	0	4	/	9	9
0	1	/	0	5	/	9	9
0	2	/	0	5	/	9	9
0	3	/	0	5	/	9	9
0	4	/	0	5	/	9	9
0	5	/	0	5	/	9	9
0	6	/	0	5	/	9	9

It would be great if you could help me.
Thanks,

Eu Gene


<pre>