I tried this, which seem to work: specifying the cell format with a custom format YYYY.MM.DD. When I input a date in this form, it is kept this way, and is recognized as a date (possible to use it in formula). Is that not enough? Maybe I misunderstood the question. -- Cley Faye http://cleyfaye.net 2014-12-19 16:27 GMT+01:00 C. H. D. <webofht-libreoffice001@yahoo.com.hk>:
Hello all, When I enter 2015.01.01, it is recognized not as a date. How do I make it one step only? I enter it and it is detected as a date. 01-01-2015 is recognized as a date. Then I need to format this. Two steps are required. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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
-- 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