|
PureBytes Links
Trading Reference Links
|
Hello Wallace,
The excel option is the simplest way. Import the ASCII
data into Excel. While importing, select the column as
a date, using the DMY drop down option.
Then select the column, which has the dates, change
its properties, by Using Format\Cells\. Under the
Numbers Tab, select custom, and in the Type window,
input yyyymmdd.
Your job should be done.
Dusant
----- Original Message -----
From: "murusprimus" <sace@xxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Thursday, October 05, 2006 10:55 PM
Subject: (????-??????????)[EquisMetaStock Group]
Change Date
>I need to change ascii price data ddmmyyyy date
format to yyyymmdd
>
> is there a program that can do the conversion ? or
> how can I change/convert the date ?
>
> have tried using Excel but nothing's working so far.
>
> TIA. Wallace
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/
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/
|