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://www.ofease.com/
CPHennessy wrote:
On Monday 22 August 2005 09:26, + Oh Chye Yong wrote:
[ MODERATED ] ***********************
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?
As you are not subscribed you may not have seen that:
On Monday 22 August 2005 16:47, David Chapman wrote:
Double Doh!
=DATEVALUE(B3) should also work :( :(
But you could always impress your co workers with the fancy formula :(
On 8/22/05, David Chapman <[EMAIL PROTECTED]> wrote:
Doh!
Wrong formula...
=DATEVALUE(LEFT(B3;2)&"/"&MID(B3;4;2)&"/"&RIGHT(B3;4))
On 8/22/05, David Chapman <[EMAIL PROTECTED]> wrote:
Here is the formula...
=DATEVALUE(LEFT(B3;2)&"/"&MID(B3;3;2)&"/"&RIGHT(B3;2))
Here is more information...
http://www.openofficetips.com/blog/archives/2005/02/converting_text.html
Please reply to users@openoffice.org only.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]