Hi :) I think you meant "Writer" rather than "Word"! Also "Calc" rather than "Excel". However those sorts of tricks often work in all sorts of different Office suites. I would probably have used a text-editor rather than W* to avoid any weird formatting creeping in but you did the same by paste-special - "as unformattted text"
Nicely done and a good answer imo :) Regards from Tom :) On 13 April 2015 at 07:58, bhaumikdave <davebhaumi...@gmail.com> wrote: > > 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: users+unsubscr...@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 > > -- To unsubscribe e-mail to: users+unsubscr...@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