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@example.com 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