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 [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
