LibO, 5.4.1/Linux Mint 17.3
When I want to enter a date I would like to enter it in short way
At the end the date should look like: Friday, 31-Mar-2018 - for this I know how to set the format.
To enter the date, I need to enter 03/31/18. I don’t like this format (mm/dd/yy) because I never use it.
I remember that in older versions of Calc I could enter the date like 18/03/31 and it changed to the format I wanted.
Mark the desired cells.
In the menu choose Format>Cells.
The dialog box “Format cells” opens.
There you select the tab “Numbers”.
With “category” you select “date”.
With “Format” you can choose a date format, e.g. “Friday, 31.12.1999”.
The date specified in the cell is displayed on the right side of the dialog box in the selected format.
The format selection offers a large number of formats.
If the format suits you, click OK.
If you need your desired date format more often, you can create a document template.
Thanks for your help. However I was interested in the entering pattern not in change of the displayed format. In case someone wants to change the displayed format, your advice is correct.
Please set Date acceptance patterns as you need.
Personally I’d advise to stick to using “YYYY-MM-DD” date pattern for input; it’s accepted unconditionally.
Your link to the acceptance patterns was useful. I read them and went into tools > options > language settings > languages > date acceptance patterns. There is the way to enter dates encoded.
With the setting/ Y/M/D the problem was solved.
Thanks for your help!