On 29 November 2011 10:26, Jeff Newmiller <jdnew...@dcn.davis.ca.us> wrote: > You haven't indicated how you are accessing the Excel file, or whether it is > an XLS or XLSX file. It sounds like you might be using rcom or a dependent > package, in which case you may need to read the Excel COM interface > documentation more carefully. In any event, you can't expect as.Date to > understand the floating-point numbers as if they were formatted dates it they > aren't.
I'm using the xlsx package to access this file. It is an XLS file. I think I got it sorted though. The column that has the problem has NA's, whereas the column that does not is complete. > For my part, I highly recommend exporting to CSV before importing to R. Will look into doing so... -- Sent from my mobile device Envoyait de mon portable ______________________________________________ R-help@r-project.org 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.
