Could you please post your code and some sample data? http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example
On 20 August 2014 17:43, Sneha Bishnoi <sneha.bish...@gmail.com> wrote: > Tried that..does not help :( > > > > On Wed, Aug 20, 2014 at 8:03 AM, Saurabh Agrawal <sagra...@idrcglobal.com> > wrote: > >> Maybe converting POSIXct to character string using "format" before >> writing to csv will help. >> >> >> >> On 20 August 2014 17:23, Sneha Bishnoi <sneha.bish...@gmail.com> wrote: >> >>> Hi All! >>> >>> This seems to be trival but I am not able to find a solution for it. >>> I have a dataframe with datetime columns in form of ("%d/%m/%y >>> %H:%M:%OS"). >>> >>> I write it to csv file. Whne i open the csv file the date time format are >>> in some number form . >>> So even if I use custome settings from excel to change it into date time >>> format, it gives me wrong value. >>> >>> My data frame is as below: >>> >>> PostDate Status ArrTime >>> NumGuests >>> 2014-08-14 16:13:08.850 O 2012-01-13 >>> 00:00:00.000 >>> 6 >>> 2014-08-14 16:13:08.850 A >>> >>> >>> -SB >>> >>> [[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. >>> >> >> > > > -- > Sneha Bishnoi > +14047235469 > H. Milton Stewart School of Industrial & Systems Engineering > Georgia Tech > [[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.