Ask Your Question

writing month+year in a libreoffice calc cell

asked 2017-07-23 11:38:38 +0200

Teonisto gravatar image

If I write, for example, october 2016 in a libreoffice calc cell, in the cell I see 2016.10.01. What do I have to do to see october 2016, as I wrote it?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-07-23 12:22:41 +0200

Kruno gravatar image

updated 2017-07-23 13:42:53 +0200

When you enter 'october 2016', LO automatically format that cell as date. You could keep cell formating as date and just change date display. To do so, right click on the cell, choose Fromat cell, choose date, and in format code enter MMMM YYYY.

Other solution is to format cell as text. Note date cell formated as date are not good for doing spreadsheet date related operations and calculations.

edit flag offensive delete link more


If I enter format date MMMM YYYY, I read october YYYY, and not october 2016. What I need is format text. Thank you

Teonisto gravatar imageTeonisto ( 2017-07-23 12:51:18 +0200 )edit

Sorry, i use italian as language. If I enter data format MMMM AAAA is ok

Teonisto gravatar imageTeonisto ( 2017-07-23 12:53:02 +0200 )edit

Accepting the recognition of "october 2016" as a date will convert it to a number representing the first day of the month. There is no representation specified for "only-month-dates". Thus the display achieved with the MMMM YYYY format code is lying in a sense. It tells less than it pretends to know.
If you intended to get a "subheading" in a list of dates, and later attempt to COUNT the number of dates entered , this kind of subheading will be counted, too.

Lupp gravatar imageLupp ( 2017-07-23 13:08:14 +0200 )edit

@Teonisto : if you got satisfying answer to your question, could you please accept the one that worked for you? Other could benefit from it. Thanks

Kruno gravatar imageKruno ( 2017-07-23 13:13:23 +0200 )edit

My preferred advice: Enter october_2016 / ottobre_2016 and make clear this way what you intended for the software and for the human reader as well: A text acting as a subheading most likely.
To avoid errors and wrong or misleading results by spreadsheets the leading principle is: Be explicit!

By the way: Subtiles / headings interrupting entered data aggravate evaluations in many cases.

Lupp gravatar imageLupp ( 2017-07-23 13:20:29 +0200 )edit

How can I accept it? I find your answer satisfying

Teonisto gravatar imageTeonisto ( 2017-07-23 13:23:14 +0200 )edit

Click the checkmark.

Lupp gravatar imageLupp ( 2017-07-23 13:25:31 +0200 )edit

To Lupp; I meant to insert a datum referred to a month.

Teonisto gravatar imageTeonisto ( 2017-07-23 13:26:38 +0200 )edit

OK. It will be the first day then. You should actally accept @Kruno 's answer.

Lupp gravatar imageLupp ( 2017-07-23 13:28:17 +0200 )edit

No, it's not the first day, it's the quantity referred to a month. October 2016 - 150; November 2016 - 180

Teonisto gravatar imageTeonisto ( 2017-07-23 14:56:54 +0200 )edit

answered 2017-07-23 13:01:04 +0200

Lupp gravatar image

updated 2017-07-23 13:16:03 +0200

Kruno gravatar image

What do you want to achieve by that sheet?
Spreadsheet software is made to provide functionality, not to put arbitrary things into cells.
The Q&D way:
Entering 'october 2016 (in an English locale) would display the entered character string "as is", but without the apostrophe. Please note that the result is not a date in Calc terms.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-23 11:38:38 +0200

Seen: 1,175 times

Last updated: Jul 23 '17