On Fri, Jul 30, 2010 at 1:17 PM, Hongying Li <colorl...@hotmail.com> wrote: > > I just do not want the dates format change randomly (seems to me) each time > I read it from excel2007 file into R. > When I export the excel2007 fiel into csv file and use read.csv function then > the dates all come out good (as mm/dd/yyyy in csv file). > I guess I have to first import into csv file before reading into R. Just > avoid reading from Excel2007 files directly. > Thanks, > Hongying >
You could try the various alternatives in the list on this page: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel and see if any of them work in the way you wish. ______________________________________________ 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.