Path: news.mathworks.com!newsfeed-00.mathworks.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!b31g2000prb.googlegroups.com!not-for-mail
From: gmtechproject@gmail.com
Newsgroups: comp.soft-sys.matlab
Subject: Re: Write date in excel
Date: Tue, 4 Nov 2008 16:51:32 -0800 (PST)
Organization: http://groups.google.com
Lines: 50
Message-ID: <393af7cc-5e8a-48ee-ae33-d537ec8e1127@b31g2000prb.googlegroups.com>
References: <a3aebc93-c3b0-408a-9533-b11361f006ac@r15g2000prh.googlegroups.com>
NNTP-Posting-Host: 117.198.146.30
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1225846292 17234 127.0.0.1 (5 Nov 2008 00:51:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 5 Nov 2008 00:51:32 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b31g2000prb.googlegroups.com; posting-host=117.198.146.30; 
	posting-account=p_L8WgoAAAAFMe0lNcT-Jfik08iYcrvQ
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 
	5.1),gzip(gfe),gzip(gfe)
Xref: news.mathworks.com comp.soft-sys.matlab:498972


On Nov 4, 4:23=A0pm, Rosy <egrosa...@gmail.com> wrote:
> 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 =3D [730238
> 730239
> 730240
> 730241
> 730242
> 730243
> 730244
> 730245
> 730246
> 730247];
>
> Date =3D datestr(A);
> xlswrite(xlsfilename, Date);
>
> However, the dates were not written in a cell but as follows
>
> 2 =A0 =A0 =A0 8 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 4 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
> 2 =A0 =A0 =A0 9 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 4 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
> 3 =A0 =A0 =A0 0 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 4 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
> 0 =A0 =A0 =A0 1 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 5 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
> 0 =A0 =A0 =A0 2 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 5 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
> 0 =A0 =A0 =A0 3 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 5 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
> 0 =A0 =A0 =A0 4 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 5 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
> 0 =A0 =A0 =A0 5 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 5 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
> 0 =A0 =A0 =A0 6 =A0 =A0 =A0 / =A0 =A0 =A0 0 =A0 =A0 =A0 5 =A0 =A0 =A0 / =
=A0 =A0 =A0 9 =A0 =A0 =A0 9
>
> It would be great if you could help me.
> Thanks,
>
> Eu Gene
you can write your data with comma separated values in notepad,and
save with extension .csv it automatically  write in column wise.then
you can read the data from excel sheet.