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. -- View this message in context: http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146086.html Sent from the Users mailing list archive at Nabble.com. -- 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
