Reputation: 9
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)
=CONCATENATE("Printing Date: ", NOW())
, it will produce: 10-11-15
=CONCATENANTE("Printing Date: :,MONTH(NOW))
this will produce:
MONTH(NOW())
, but I want the output as November
instead of 11
, how do I do it?Are there any solution to this?
Many thanks in advance!
NB:
"Printing Date: 10-11-15 10:20"
My formula is:=CONCATENATE("Printing Date: ",DAY(NOW()),"-",MONTH(NOW()),"-",YEAR(NOW()),"
",HOUR(NOW()),":",MINUTE(NOW()))
Upvotes: 1
Views: 465
Reputation: 574
Format the cell and change the formatting to the code (MMMM), and use only NOW() (rather than MONTH(NOW()))
You say you want to prefix it with other text, how about this?
Upvotes: 1