Once the text is in a spreadsheet cell, I have found that Value() will convert the text to a date value. HTH On Mon, Jun 3, 2013 at 5:29 AM, Cor Nouws <oolst@nouenoff.nl> wrote:
Hi Joel, Joel Madero wrote (01-02-13 05:08) I have a macro that converts QIF files to a spreadsheet. I have a fewthings left to do and one of these is that the column for dates are currently in text format: "dd.mm.yyyy"there is this one http://extensions.libreoffice.**org/extension-center/ct2n-** convert-text-to-number-and-**dates<http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates> (still in need for an update, but does work though..) -- - Cor Nouws - http://nl.libreoffice.org - The Document Foundation Membership Committee Member -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.org<users%2Bunsubscribe@global.libreoffice.org> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette <http://wiki.documentfoundation.org/Netiquette> List archive: http://listarchives.**libreoffice.org/global/users/<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+unsubscribe@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