On 27 Jul 2011 at 9:16, Steve Edmonds wrote: Date sent: Wed, 27 Jul 2011 09:16:02 +1200 From: Steve Edmonds <[email protected]> To: [email protected] Subject: [libreoffice-users] Calc. Changing format of data types Send reply to: [email protected]
> If I have a string in a cell, say 30/08/2011 and the format is general > (I don't know what types the data) can this be changed to a date data > type without having to re-enter all my data. > steve I just did a test on this formula seemed to work for me, but my system uses mm/dd/yy. A1 has text 30/08/2011 B1 has formula =DATEVALUE(MID(A1,4,2)&"/"&MID(A1,1,2)&"/"&MID(A1,7,4)) Which converts the value, but it would require positions would have to be exactly correct. A2 has text 08/30/2011 B2 has forumula =DATEVALUE(A2) perhaps DATEVALUE would work with the DD/MM/YYYY format if that is the default for your setting? Get the formula in another column, and then do a copy special to copy the value back to the original column. +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:[email protected] mailto:[email protected] http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI 11049520.801658 | EINSTEIN 6250137.750851 ROSETTA 3423708.263834 | ABC 7106273.678421 -- Unsubscribe instructions: E-mail to [email protected] 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
