|
PureBytes Links
Trading Reference Links
|
whoops, I should have said:
...I don't know why the '04' in
'04/14/3' <FONT color=#ff0000
size=6>,which is actually 'YY/DD/M' in the XLS file<FONT
color=#ff0000 size=6>,converts to 4/14/2003 in the CVS file.
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
john gibb
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Tuesday, March 16, 2004 12:27
PM
Subject: Re: [amibroker] I have a problem
with Export .csv and Import Wizard
Hi Ron,
see green below
----- Original Message -----
From: "ronbo" <<A
href=""><FONT face=Arial
size=2>ronbo@xxxxxxxxxxxxxx<FONT face=Arial
size=2>>
To: <<A
href=""><FONT face=Arial
size=2>amibroker@xxxxxxxxxxxxxxx<FONT face=Arial
size=2>>
Sent: Tuesday, March 16, 2004 10:54
AM
Subject: RE: [amibroker] I have a problem with
Export .csv and Import Wizard
thanks John for the reply--re #1--yea i knew
it was something like that--i thought it was a bigger #thore
#2--when i view your .csv file, the YDM format is displayed as
4/14/2003.
I show this as well; Other than
because of an Excel bug, I don't know why the '04' in '04/15/3' which is
actually 'YY/DD/M' in the XLS file converts to 4/14/2003 in the CVS
file.
i did as you suggested and created a Custom
date format that works. thedate in the .xls file also contains the
time "3/15/2004 6:00:23 PM"--thisfrom D2.
right; this is how it
displays in the edit field, but hopefully in D2 itself, you see '15-3-2004'
(D-M-YYYY; which I mislabelled as DM-YYYY in D1)i'll try the AB
export, edit in Excel and change the Date format using acustom format and
i'll see what happens and then Import.good
luck!
thanks,ron-----Original
Message-----From: john gibb [mailto:jgibb1@xxxxxxxxxxxxx]Sent: Monday,
March 15, 2004 6:10 PMTo: <A
href=""><FONT face=Arial
size=2>amibroker@xxxxxxxxxxxxxxx<FONT face=Arial
size=2>Subject: Re: [amibroker] I have a problem with Export .csv and
ImportWizardHi Ron,1) the 'large number' is the number
of days since 1/1/1900 or thereabouts.2) RE changing your date format:
see the attached where I have done justthat (with Excel 97, no less!) via
Format | Cells | Category: Custom (andthen just put in the Type field:
'm/d/yy', 'y/d/m', or 'd-m-yyyy')HTH,-johnPS: I also
included the CSV file created from the XLS file, via Save
As---Outgoing mail is certified Virus Free.Checked by AVG
anti-virus system (<FONT face=Arial
size=2>http://www.grisoft.com).Version:
6.0.619 / Virus Database: 398 - Release Date:
3/10/2004------------------------ Yahoo! Groups Sponsor
---------------------~-->Buy Ink Cartridges or Refill Kits for your HP,
Epson, Canon or LexmarkPrinter at MyInks.com. Free s/h on orders $50 or
more to the US & Canada.<A
href=""><FONT face=Arial
size=2>http://www.c1tracking.com/l.asp?cid=5511<A
href=""><FONT
face=Arial
size=2>http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM<FONT
face=Arial
size=2>---------------------------------------------------------------------~->Send
BUG REPORTS to <FONT face=Arial
size=2>bugs@xxxxxxxxxxxxxSend
SUGGESTIONS to <FONT face=Arial
size=2>suggest@xxxxxxxxxxxxx<FONT face=Arial
size=2>-----------------------------------------Post AmiQuote-related
messages ONLY to: <FONT
face=Arial size=2>amiquote@xxxxxxxxxxxxxxx
(Web page: <A
href=""><FONT face=Arial
size=2>http://groups.yahoo.com/group/amiquote/messages/<FONT
face=Arial size=2>)--------------------------------------------Check
group FAQ at: <A
href=""><FONT
face=Arial
size=2>http://groups.yahoo.com/group/amibroker/files/groupfaq.html<FONT
face=Arial size=2> Yahoo! Groups Links<*> To visit your
group on the web, go to: <A
href=""><FONT face=Arial
size=2>http://groups.yahoo.com/group/amibroker/<FONT
face=Arial size=2><*> To unsubscribe from this group, send an email
to: <A
href=""><FONT face=Arial
size=2>amibroker-unsubscribe@xxxxxxxxxxxxxxx<FONT
face=Arial size=2><*> Your use of Yahoo! Groups is subject
to: <A
href=""><FONT face=Arial
size=2>http://docs.yahoo.com/info/terms/<FONT face=Arial
size=2> Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/amibroker/
To unsubscribe from this group, send an email to:amibroker-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|