Ah, yes! Thanks for reminding me. I remember now, in the days before Excel
automatically opened .csv files, importing transaction lists into Excel
and Access, and / or Lotus 1-2-3, and SuperCalc, and specifying date
formats before completing the import!
Still, it would be greatly appreciated
Adam, I agree with you, and consider your pointing out the international
(ISO) standard to be quite a valuable contribution, except that I tested it
and it doesn't work in Microsoft Excel (and maybe not in any other modern
software except by indirect means!
Excel will not convert to date with
Since this format is an official ISO standard (and has been
for years), most modern software should be able to interpret
it correctly.
sarcasm
But I thought that the original question involved Microsoft Excel.
/sarcasm
-- David Beroff [EMAIL PROTECTED] Founder/CEO, LeadFactory.com
P.O. Box
Can we PLEASE have the date format changed in the .CSV e-gold history
files we save for opening in a spreadsheet?
hi ian,
try this (it works for me in ms excel 2000)...
Data - Get External Data - Import Text File ...
(pick file)
* Delimited (tell excel file is of delimited format)
Next
At 01:07 2002-03-27 +1100, Ian Green wrote:
Now I could filter e-gold's egoldhis.csv through a Perl script, but this
is inconvenient, and believe it or not, I don't have perl running on a
machine sufficiently near me at all times. Even if I did, it would be too
much trouble compared to e-gold