Thread: problem regarding date conversion

Hi All,
I have 2 sheets. In first sheet one column is there for date. But the data in that column is coming from one text file..
for example the data in text file are like this:
11/01/06 11:26:40
28/06/05 15:59:28
when i am saving this data in excel sheet it is being saved as
11/01/06
28/06/05 15:59:28
the format of the column is mm/dd/yy

but when i am copyng from this first excel sheet to second excel sheet using macro its coming correct for the first data (11/01/06) but for the secomd data its coming decimal format like 30589.3264
Please help me.
Thanks

You need to format the second cell as DATE - it would suggest it is formatted
as Number.

"ashishprem" wrote:

>
> Hi All,
> I have 2 sheets. In first sheet one column is there for date. But the
> data in that column is coming from one text file..
> for example the data in text file are like this:
> 11/01/06 11:26:40
> 28/06/05 15:59:28
> when i am saving this data in excel sheet it is being saved as
> 11/01/06
> 28/06/05 15:59:28
> the format of the column is mm/dd/yy
>
> but when i am copyng from this first excel sheet to second excel sheet
> using macro its coming correct for the first data (11/01/06) but for
> the secomd data its coming decimal format like 30589.3264
> Please help me.
> Thanks
>
>
> --
> ashishprem
> ------------------------------------------------------------------------
> ashishprem's Profile: http://www.excelforum.com/member.php...o&userid=31485
> View this thread: http://www.excelforum.com/showthread...hreadid=511712
>
>