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+h...@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
