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: [email protected] 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
