Re: [users] Changing text to date

Thanks for the response! Actually I was hoping if it can be some simple steps to reformat the strings into dates using openoffice's menu. As I have to instruct others how to do it... thanks so much though! OH Chye Yong OpenFeel Pte Ltd (200302385C) Web: http://www.openfeel.com/ http

[users] Changing text to date

Hi I have a spreadsheet that has several columns of dates but entered as text/strings (eg. '24/07/2005). How do I convert these strings to dates, so that I can do sorting? Thanks -- OH Chye Yong OpenFeel Pte Ltd (200302385C) Web: http://www.openfeel.com/ Email: [EMAIL PROTECTED