|
PureBytes Links
Trading Reference Links
|
On Thu, 19 Jun 1997 RIFKI@xxxxxxx wrote:
> It's so simple I feel downright silly asking. CONVERT THE FOLLOWING
> DATES IN EXCEL TO METASTOCKS mm/dd/yy FORMAT ! SIMPLE? NOT FOR ME.
> (Please cut&paste to Excel and then try. If you can do it, you're my
> angel). PLEASE EMAIL rifki@xxxxxxx
>
> DATE
> 900102
> 900103
etc.
A VBA macro would work if your date formatting does not:
Function ParseDate(sDate as string) as string
ParseDate=Mid$(sDate,3,2) & "/" & Right$(sDate,2) & "/" & Left$(sDate,2)
End Function
NB: you must formate the column as string (char).
Cheers,
Jim
|