|
PureBytes Links
Trading Reference Links
|
> Date: Mon, 14 Jul 1997 20:03:43 -0500
> From: Efrain R Portales <efrain12@xxxxxxxxxxxx>
> Organization: futures day trading
> To: Metastock List <metastock-list@xxxxxxxxxxxxx>
> Subject: Dates in Excel 7
> <HTML>
> Requesting help from the Excel 7 experts here.
> <BR>I downloaded some historical data as zip files, which I unzipped and
> they're shown as
> <BR>.dat files ( supposedly ASCII files ). Working with Excel 7, I saved
> them as Excel files.
> <BR>The date format shown on the first column is of this type :
> <BR>750214
> <BR>I tried to format the column do the date format : mm/dd/yy
> <BR>The result is a series of harsh marks ( ############## ).
> <BR>Since each file has more than 100 records, it would be time-consuming
> to retype the
> <BR>entire date column to the yy/mm/dd format.
> <BR>So I tried to work around this with the MID and LEFT functions.
> <BR>With example shown above, now I have in cells A1, B1 and C1 the following
> :
>
> <P>A1 B1
> C1
> D1
> <BR>02
> 14 75
> ?
>
> <P>Now, the big question : HOW DO I GET IN CELL D1 THE DATE IN
> <BR>mm/dd/yy format ? (which, in this case, should be 2/14/75 ).
>
> <P>I'm good working with Excel 7, just NOT good enough !
> :- )
>
> <P>Just to see if was lucky, I tried to convert those files to Metastock
> format
> <BR>with the Downloader, it told me : who are you trying to fool ?
>
> <P>Any help will be greatly appreciated.
>
> <P>Efrain R Portales
> <BR>efrain12@xxxxxxxxxxxx</HTML>
>
Hi
Theres an easy way to do this: Don't save as Excel files. Save as
"ASCII" and go to the Downloader and import. It should be OK. I've
done it myself.
Rifki
|