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: [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
