Thanks. I still didn't get the solution. For example, I have a data frame, called temp > temp Chr Ref Var AFF UNAFF AFF.test pvalue 1 10 A G 2/1/24 0/0/190 5/49 2.429e-09 2 18 G A 1/9/17 0/23/167 11/43 2.484e-04 3 1 G A 2/2/22 0/8/176 6/46 4.293e-04 4 11 T G 1/1/25 0/2/188 3/51 1.193e-03 5 2 A T 1/10/16 38/90/60 12/42 2.220e-03 6 3 G A 1/16/10 8/49/133 18/36 4.549e-03
Then I want to write a csv file using R function write.csv, as follows: > write.csv(temp, file="temp.csv", row.names = FALSE) and the csv file, temp.csv, looks like the below, not same as original data Chr Ref Var AFF UNAFF AFF.test pvalue 10 A G 02/01/2024 0/0/190 May-49 2.43E-09 18 G A 01/09/2017 0/23/167 Nov-43 0.0002484 1 G A 02/02/2022 0/8/176 Jun-46 0.0004293 11 T G 01/01/2025 0/2/188 Mar-51 0.001193 2 A T 01/10/2016 38/90/60 Dec-42 0.00222 3 G A 1/16/10 8/49/133 18/36 0.004549 On Fri, May 2, 2014 at 3:06 PM, Bert Gunter <gunter.ber...@gene.com> wrote: > Read your Excel documentation. AFAIK, R just writes text files -- you > need to tell Excel how to read them in. > > Cheers, > Bert > > Bert Gunter > Genentech Nonclinical Biostatistics > (650) 467-7374 > > "Data is not information. Information is not knowledge. And knowledge > is certainly not wisdom." > H. Gilbert Welch > > > > > On Fri, May 2, 2014 at 11:34 AM, ChangJiang Xu > <changjiang.h...@gmail.com> wrote: > > By dafault, write.csv will change the characters such as "5/38" as a date > > "May-38". How can I not change the format? > > Thanks. > > > > ChangJiang > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > 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. > [[alternative HTML version deleted]] ______________________________________________ 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.