Hi Either change comma to dot in Excel (but sometimes Excel is rather reluctant to accept such changes).
Or change commaa to dot in R which probably can be easily done by gsub command Or read data with option dec=",". I do not know XLConnect but in read.table it is optional parameter and maybe it is also readWorksheet. Regards Petr > -----Original Message----- > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- > project.org] On Behalf Of Knut Krueger > Sent: Monday, November 25, 2013 10:11 AM > To: r-h...@stat.math.ethz.ch > Subject: [R] XLConnect readWorksheet comma decimal sign > > Hi to all, > how can I read exel files where the decimal sign is comma instead dot. > I get the data as ascii and when converting "3,5" with as.numeric the > 3,5 will be converted to NA > > Kind Regards Knut > > ______________________________________________ > 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. ______________________________________________ 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.
