We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how to change the default entry date in Calc

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

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 +0200

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

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 +0200 )edit

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

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 659 times

Last updated: Dec 28 '18