Ask Your Question

how to change the default entry date in Calc

asked 2018-12-28 08:01:45 +0100

ROSt52 gravatar image

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.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-12-28 08:27:05 +0100

updated 2018-12-28 08:29:30 +0100

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.

edit flag offensive delete link more


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!

ROSt52 gravatar imageROSt52 ( 2018-12-28 15:30:39 +0100 )edit

answered 2018-12-28 08:20:01 +0100

ebot gravatar image

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.

edit flag offensive delete link more


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.

ROSt52 gravatar imageROSt52 ( 2018-12-28 15:31:51 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-28 08:01:45 +0100

Seen: 27 times

Last updated: Dec 28 '18