Sorry guys, I allready found the solution. Excell showed some of the numbers in the format: 1,90053-E05 and R interpreted it as 1.9... I changed that in Excel
Cheers, Anna Am 6. Oktober 2011 17:48 schrieb Uwe Ligges <lig...@statistik.tu-dortmund.de>: > > > On 06.10.2011 17:39, Anna Lee wrote: >> >> Hello everyone! >> >> I work with a german excell version which uses commas instead of >> points for seperating decimal places. R work with points so in order >> to be able to save my excell tables without changing the commas to >> points, whenever I load a table I type in: read.table(..., dec = ",") >> only R puts the points into the wron places. For excample excell has a >> cell with the number: 0,09 so what R does, it writes the number as 0.9 > > Please specify an example with the excel output and what R reads. You will > find that such an example does not exist and hence you made some mistake and > compared different numbers or so. > > Uwe Ligges > > >> which is wrong and makes my calculations become useless. >> >> Does anyone know this problem? Maby I made a mistake somewhere? >> >> I would be glad about your answers! >> >> Cheers, Anna >> > -- Der Inhalt dieser E-Mail ist vertraulich. Sollte Ihnen die E-Mail irrtümlich zugesandt worden sein, bitte ich Sie, mich unverzüglich zu benachrichtigen und die E-Mail zu löschen. This e-mail is confidential. If you have received it in error, please notify me immediately and delete it from your system. ______________________________________________ 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.