Am 20.03.2015 um 05:56 schrieb Emil Payne: > On 19/03/15 08:28 PM, James wrote: >> Column A has text strings that are DD/MM/YYYY format. >> I want to make them real dates. >> I tried these 2 datevalue formulas but I can't make it work. >> >> 14/03/2015 Err:502 >> 14/03/2015 Err:502 >> >> >> =DATEVALUE(TEXT(A1,"##/##/####")) >> =DATEVALUE(A2) >> > Highlight the cells > Right click > FORMAT CELLS > NUMBERS tab > In the FORMAT CODE block at the bottom, put > DD/MM/YYYY > >
No, this won't work. You've got to change the global locale option in order to change the evaluation context for existing data. Other method: =DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)) -- To unsubscribe 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
