Hi :) Is this set-up in somewhere weird like Format - "Styles and Formatting"?
Maybe one of the early chapters in the Published Guides might be able to help set it more permanently; https://wiki.documentfoundation.org/Documentation/Publications Ahh, chapter 3 of the "Getting Started Guide" is about styles. Regards from Tom :) On 14 October 2014 21:50, Jim Byrnes <[email protected]> wrote: > On 10/14/2014 03:20 PM, bunk3m wrote: > >> Libreoffice is driving me nuts. >> >> I am in Canada. UI is set to English US; Locale settings to English >> Canada and Default Currency is CAD. >> >> I have my Mac set dates to dd.mm.yyyy. (OSX 10.9.x) >> >> For some reason Libreoffice (4.3.1.2) will only accept dates in the >> YYYY-MM-DD format. >> >> I'm happy that I can format the date to look DD.MM.YYYY but entering in >> the YYYY-MM-DD is totally unnatural for me. >> >> Actually, I only usually type the DD.MM and expect the YYYY to show up >> automatically in Excel. I'd like the same behaviour in LO if possible. >> >> The date acceptance patterns will not accept anything except what is >> loaded by default ... which is >> D.M.YYYY;DD-MM-YYYY;D-M >> >> I don't want to have to type the YYYY each time for D.M.YYYY. >> >> I've tried to add D.M to the acceptance pattern but the text turns red >> and won't save. The D.M is always gone after trying to save. >> >> So if the date acceptance patterns are supposed to be customizable by >> the user ... >> >> what do I have to do to get this to work? >> >> Thanks in advance. >> B. >> >> PS I'm on digest mode. Please CC me directly >> >> > Try this: > > right click on a cell > select Format Cells > in category choose User Defined > in Format code enter: 00"."00".2014" > > Then you can go to that cell and enter for example: 2512 and it should > display as 25.12.2014. > > A couple of things to remember. This looks like a date but I don't think > you could do date math with it. I do this all the time but I just need it > to visually look like a date. Also in 86 years you will need to rewrite it. > > Regards, Jim > > > > -- > 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 > -- 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
