[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: whip your puney asteroids:



PureBytes Links

Trading Reference Links

Hi Rifki

The date format in Excel will work if you set is as mm/dd/yy. I do this
with formulas all the time.

Go to Format, Cells, date, then enter the format you want in the popup
window. then click ok and It should change the entire col.. You must have
col Highlighted.

Regards

Michael
----------
> From: RIFKI@xxxxxxx
> To: metastock-list@xxxxxxxxxxxxx
> Subject: Excel to Metastock Coversion
> Date: Wednesday, June 18, 1997 8:34 AM
> 
> I've just joined the Forum and guess what, have an immediate problem!
> Why on earth does Metastock use the date format of "mm/dd/yy", I am 
> finding it impossible to convert all the  data I downloaded from the 
> Internet , all of which have "yyddmm". The Date Format option in 
> Excel just doesn't work. PLEASE HELP.
> 
> Rifki Sameem
> rifki@xxxxxxx
>