[EquisMetaStock Group] Re: request to change the date to numbers for furthe calculations.

["rsb_44" <rsb_44@xxxxxxxxxxx>]

You can use Excel:

Assuming the date is in A1

=Value(LEFT(TEXT(A1,"m/dd/yyyy"),1)&MID(TEXT(A1,"mm/dd/yyyy"),4,2)
&RIGHT(TEXT(A1,"m/dd/yyyy"),4))

should do it. 

However, once you're in Excel you might as well do the work in Excel 
(you can use Excels date/time calculation abilities) and then use 
MasterDatacsv. 

http://www.metastockcsv.com/


Ron

--- In equismetastock@xxxxxxxxxxxxxxx, "krishnapvm" <krishnapvm@xxx> 
wrote:
>
> i request one and all to throw light on how i can convert date to 
> numbers for example 06/09/2008 to a number like6092008.
> thanks in advance.
>



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/