Re: [libreoffice-users] Calc. Changing format of data types

On 27 Jul 2011 at 9:16, Steve Edmonds wrote:

Date sent:              Wed, 27 Jul 2011 09:16:02 +1200
From:                   Steve Edmonds <steve.edmonds@ptglobal.com>
To:                     users@global.libreoffice.org
Subject:                [libreoffice-users] Calc. Changing format of data 
types
Send reply to:          users@global.libreoffice.org

> 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:mikes@kuentos.guam.net                            
  mailto:msetzerii@gmail.com
  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 users+help@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