Why don't you use a package like RODBC and read the data directly from the Excel file? Then you probably won't have to worry on how to get the dates in the right format.
Another, maybe easier, solution is to export the Excel to CSV and then use read.csv(). Cheers, Thierry ------------------------------------------------------------------------ ---- ir. Thierry Onkelinx Instituut voor natuur- en bosonderzoek / Research Institute for Nature and Forest Cel biometrie, methodologie en kwaliteitszorg / Section biometrics, methodology and quality assurance Gaverstraat 4 9500 Geraardsbergen Belgium tel. + 32 54/436 185 [EMAIL PROTECTED] www.inbo.be Do not put your faith in what statistics say until you have carefully considered what they do not say. ~William W. Watt A statistical analysis, properly conducted, is a delicate dissection of uncertainties, a surgery of suppositions. ~M.J.Moroney > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Namens dala > Verzonden: donderdag 21 juni 2007 15:54 > Aan: [email protected] > Onderwerp: [R] sorting data > > > I have a 2 columns, Date and Number, in Excel. > I copy and paste them into Notepad. > I can use scan() to import the file but how do I plot this > data with Date as the x-axis? > -- > View this message in context: > http://www.nabble.com/sorting-data-tf3958889.html#a11233613 > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
