[libreoffice-users] Re: converting txt to dates

Am 13.04.2015 um 16:22 schrieb Andreas Säger:
> Am 13.04.2015 um 08:58 schrieb bhaumikdave:
> > Hi, I got a simple solution to this. My date format in excel sheet was like
> > 12-04-2015.
> >
> > Excel was not recognizing it as date or Formatting cell to Date was helping
> > me.
> >
> > So I selected and Copied entire column of date to New Blank Word document.
> >
> >   Then I Again copied the date column from word document and came back to my
> > original excel sheet.
> >
> > Then right click and press Pest Special -->Paste as TEXT.
> >
> > Done. Now Excel will recognize it as date and will allow you to format cells
> > any date format as you wish. 
>
> What is particularly irritating about your oversimplified approach with
> WinWord and Excel is that it is not reproducible with LibreOffice.
> It may work with Calc and a plain text editor (or not, depending on the
> outlined details).

How does your Excel handle the following data set?

04/12/2015
04/13/2015
04/14/2015
04/10/2015
04/14/2015



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted