Thanks to both of you!
Best, Joel On Mon, Jun 3, 2013 at 8:09 AM, Paul Schwartz <[email protected]> wrote: > 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 <[email protected]> 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 few >>> things 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%[email protected]> >> >> 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 >> >> > -- *Joel Madero* LibreOffice QA Volunteer [email protected] -- 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
