Idad
Idad

Reputation: 9

Formating dates style in LibreOffice Calc Formula

Original Question
I just editing a spreadsheet file using LibreOffice Calc 5.0.2.2 and entering formula in cell A1 =MONTH(NOW()). Obviously, it will print out in cell A1: as 11, as the curent month is 11th Month, November.

What I want to ask is, if I want to use DATE formula as above (=MONTH(NOW())), but I want the output as November instead 11, how do I do it?

Addendum (Revised)

Are there any solution to this?

Many thanks in advance!

NB:

Upvotes: 1

Views: 465

Answers (1)

u8sand
u8sand

Reputation: 574

Format the cell and change the formatting to the code (MMMM), and use only NOW() (rather than MONTH(NOW()))

Dialog

You say you want to prefix it with other text, how about this?

enter image description here

Upvotes: 1

Related Questions