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

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.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


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