On Fri, 20 Mar 2015 12:00:02 +0100 Andreas Säger <ville...@t-online.de> wrote:
> 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)) > > > Please leave original context in replies. Stripping original content makes it more difficult to track conversations without going back through the entire message thread. Thanks, Tom :-) -- You don't get to choose how you're going to die, or when. You can decide how you're going to live now. -Joan Baez ^^ --... ...-- / -.- --. --... -.-. ..-. -.-. ^^^^ Tom Taylor KG7CFC openSUSE 13.1 (64-bit), Kernel 3.11.6-4-default, KDE 4.11.2, AMD Phenom X4 955, GeForce GTX 550 Ti (Nvidia 337.19) 16GB RAM -- 3x1.5TB sata2 -- 128GB-SSD FF 36.0, claws-mail 3.10.1 registered linux user 263467 -- To unsubscribe e-mail to: users+unsubscr...@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