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

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 oo...@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

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 pmjs1...@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 oo...@nouenoff.nl wrote: Hi

[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

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

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 to

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