Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.