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
Thierry.Onkelinx op inbo.be
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: r-help-bounces op stat.math.ethz.ch
> [mailto:r-help-bounces op stat.math.ethz.ch] Namens dala
> Verzonden: donderdag 21 juni 2007 15:54
> Aan: r-help op stat.math.ethz.ch
> 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.
>
> ______________________________________________
> R-help op stat.math.ethz.ch 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.
>