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

On 01/31/2013 09:46 PM, Andrew Douglas Pitonyak wrote:
> On 01/31/2013 11:08 PM, Joel Madero wrote:
> > Hi All,
> >
> > 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"
> >
> > I want to convert this to a date format through a macro. Note that 
> > selecting these cells and just doing format - Cell and setting to 
> > Date does NOT change the formatting to a date.
> >
> >
> > Thanks in advance.
> >
> >
> > Joel
> Are you asking how to convert text in the form dd.mm.yyyy to a date, 
> or are you asking how to format a cell to format the date as dd.mm.yyyy?
>
> Just thought that I would mention it.
Convert text in the form of dd.mm.yyyy to a date

Trying the first post, thanks to that reply as well


Best,
Joel

--
For unsubscribe instructions e-mail to: users+help@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