Re: [libreoffice-users] Macro to Convert Date in Text Format to Date in Date Format (Spreadsheet)

Thanks to both of you!


Best,
Joel


On Mon, Jun 3, 2013 at 8:09 AM, Paul Schwartz <pmjs1115@gmail.com> 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 <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 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%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


-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero.dev@gmail.com

-- 
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