Hi :) So it's picking up the USA locale for it's input? I thought LibreOffice could have it's own locale as somethign different from the system's one? Regards from Tom :)
On 19 February 2015 at 17:26, Mark Howe <markh...@cox.net> wrote: > Yeah, I tho't of that and tried changing it around to 14 Jan 2014. > The only thing that worked was changing it to Jan 14 2014 and then it > worked automatically in it’s own column making the exercise with datevalue > of no value. > > 14 Jan 2014 Err:502 > 01/10/14 Err:502 > 01/02/14 Err:502 > 25 February 2014 Err:502 > 25 February 2014 Err:502 > 25 February 2014 '=DATEVALUE(A6) > 30 March 2014 > > > This is what it looks like, 2 col starting with A1 [no col heading]. Line > 6 so’s you can see what the formula looks like. > > Mark W. Howe > San Juan Capistrano, CA > 949-496-3453 home/ office > 949-525-3914 cell [not for messages] > > "Phao Binh" > http://swcenter.fortlewis.edu/finding_aids/inventory/2008008.pdf > -----Original Message----- > From: Brian Barker > Sent: Thursday, February 19, 2015 7:34 AM > To: users@global.libreoffice.org > Cc: Mark Howe > Subject: Re: [libreoffice-users] Formatting a date > > At 07:19 19/02/2015 -0800, Mark Howe wrote: > >-----Original Message----- From: Brian Barker > >Sent: Thursday, February 19, 2015 7:05 AM > >Subject: Re: [libreoffice-users] Formatting a date > >> > >>At 06:41 19/02/2015 -0800, Mark Howe wrote: > >>>I have text: 19 February 2015. The format for the cell is date > >>>2/19/2015, but it will not acknowledge that or sort correctly. As > >>>if it's formatted for date but not accepting that fact. What did I do > wrong? > >> > >>If you want your existing values to be genuine dates - as you will > >>want to do if you need to include them in calculations or even just > >>sort them - you must first convert the text into the equivalent > >>date. Fortunately. the DATEVALUE() function is available to do this > >>for you. Just put =DATEVALUE(Xn) in another column and fill down. > > > >I interpreted what you wrote to mean that =datevalue(a1) would > >convert the contents of A1 into a date. > > Yup - provided that the value in A1 is a "valid date expression". > > >It did not and produced err502. What am I missing? > > Then what is in A1 cannot be what Calc considers (in your locale) to > be a valid date expression. The DATEVALUE() function seems very > robust to me: it can cope with many date formats and doesn't seem to > be fazed by extra blanks, though it can be by extraneous commas. > > Is it possible that you have a column heading in A1? > > I trust this helps. > > Brian Barker > -- > 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 > -- 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
