Add the input format to your Date acceptance pattern? Tools -> Language Settings -> Languages: Language Of... Date acceptance patterns
-=from en-US help=- Date acceptance patterns Specifies the date acceptance patterns for the current locale. Calc spreadsheet and Writer table cell input needs to match locale dependent date acceptance patterns before it is recognized as a valid date. Default locale dependent date acceptance patterns are generated build time, but it is possible to add more or modify them in this edit box. Additionally to the date acceptance patterns defined here, every locale accepts input in an ISO 8601 Y-M-D pattern, and since LibreOfficeDev 3.5 that also leads to the YYYY-MM-DD format being applied. Syntax: Y means year, M means month, and D means day, regardless of localizaton. -- View this message in context: http://nabble.documentfoundation.org/Dot-separated-date-in-YYYY-MM-DD-format-tp4133212p4133233.html Sent from the Users mailing list archive at Nabble.com. -- 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