Re: [libreoffice-users] MONTH() and YEAR() functions behave differently in scalc 3.5.7 and 4.x

Thomas Boehm wrote:
> Brian Barker wrote:

> > in your case.  Your first question should be what happens if you enter
> > 10/2013 into an unformatted cell: do you see a date value, perhaps 1
> > October 2013, or do you see the text string you entered?
>
> I see the text string entered, but the formatting says "Number - General".
>
> > Note that the date acceptance patterns can now be adjusted at Tools |
> > Options... | Language Settings | Languages | Language of | Date
> > acceptance patterns.  Note also that the ISO format YYYY-MM-DD works in
> > all locales, so is most reliable.
>
> When I add ;M/Y nothing changes. Or did you mean, that after this change
> if I enter 10/2013 into the cell it should be formatted as date? Then
> this doesn't work.

Of course I had to replace D/M with M/Y and not just add it. Now it
works and "01/10/13" appears when I enter "10/13".


-- 
To unsubscribe e-mail to: users+unsubscribe@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