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

2013-06-03 Thread Joel Madero
Thanks to both of you! Best, Joel On Mon, Jun 3, 2013 at 8:09 AM, Paul Schwartz 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 wrote: > >> Hi Joel, >> >> Joel Madero w

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

2013-06-03 Thread Paul Schwartz
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 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 l

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

2013-06-03 Thread Cor Nouws
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." there is this one http://extensions.libreoffice.org/extension-center/ct2

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

2013-01-31 Thread Brian Barker
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.". I want to convert this to a date format through a macro. Note that y

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

2013-01-31 Thread Joel Madero
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." I want t

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

2013-01-31 Thread Andrew Douglas Pitonyak
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." I want to convert this to a date format through a macro. Note th

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

2013-01-31 Thread Joel Madero
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." I want to convert this to a date format through a macro. Note that selecting these cells and just doing for