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

At 20:08 31/01/2013 -0800, Joel Madero wrote:
> 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 you may not need a macro at all: you could create an 
additional column with a formula to evaluate a genuine date value 
from the data in your text column.  You could even hide the column of 
original text values if you preferred.

One formula that might work is
 =DATEVALUE(Xn)
but whether this will handle your DD.MM.YYYY may depend on your 
locale setting.  Otherwise, something such as
 =DATE(RIGHT(Xn;4);MID(Xn;4;2);LEFT(Xn;2))
ought to work.

Alternatively, does this point you in the right direction to create a macro?

I trust this helps.

Brian Barker


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