Ask Your Question

Typing a date in Calc

asked 2019-05-16 23:53:11 +0200

JayCee gravatar image

I am new at LibreOffice. But I want to use LibreOffice (and not Office (Excel) anymore) !! But when I typed a date in Excel, I typed f.e. 12-3 and in a cell from Excel there came 12 march 2019. I can not get that in LibreOffice !!??? Why not? Why can I not type just day and month, and then LibreOffice gets the full date in the cell ?? Can you please help me with this? JayCee

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted

answered 2019-05-17 02:25:20 +0200

Format the cell before: In Format / Cells / Date and select the format you want. The typing and 12/3 the year he considers the current.

edit flag offensive delete link more

answered 2019-05-17 14:09:12 +0200

erAck gravatar image

It depends on the locale you work in (which?) and what date separator that locale uses, and related on the active date acceptance patterns. See Tools -> Options -> Language Settings -> Languages. If your locale uses a different date separator than - and you want to be able to use the - nevertheless to enter an abbreviated date then add D-M to the Date acceptance patterns, separated with a semicolon. For example if your locale's default patterns are D/M/Y;D/M that would be D/M/Y;D/M;D-M

edit flag offensive delete link more

answered 2019-05-18 01:35:52 +0200

JayCee gravatar image

Okay! I have to type 12/3 (instead of 12-3), and then the year comes with it. Thank you for your answer !!

edit flag offensive delete link more

answered 2019-05-17 15:47:31 +0200

Lupp gravatar image

updated 2019-05-20 22:42:32 +0200

Go to Tools>Options>Language settings>>Date acceptance patterns.

Append ;D-M there and delete patterns that might possibly be in conflict.

For the display of dates you should use YYYY-MM-DD wherever possible. That's a matter of the number format you set for the cell now.

Don't mix up the so-called recognition and formatting.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-16 23:53:11 +0200

Seen: 87 times

Last updated: May 20 '19