bhaumikdave wrote on 13-04-15 08:58:
Done. Now Excel will recognize it as date and will allow you to format cells any date format as you wish.
No idea what Excel does or not or what proper date handling would be most ideal. You may try this one however ;) http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates Cheers, Cor -- Cor Nouws GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28 A038 E49D 7365 B134 80A6 - vrijwilliger http://nl.libreoffice.org - volunteer http://www.libreoffice.org - The Document Foundation Membership Committee Member -- To unsubscribe e-mail to: firstname.lastname@example.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