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 <oo...@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 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%2bunsubscr...@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+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