Andreas Säger wrote: > Problem is that too many spreadsheet users do not know what a > spreadsheet date/time is and how it differs from a text such as > "16/07/2015" which is not a date by any means.
Actually it is if you add the pattern to Options > Language Settings > Languages > Date Acceptance Patterns. I had previously added D/M/Y and "16/07/2015" (without the quotes) was perfectly recognized as a date. To keep the formatting you must also adapt the cell formatting. -- Piet van Oostrum <[email protected]> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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
