I've already posted the solution. Just remove the call to month and do.
=text (now (),"MMM")
Regards,
Tony.
Sent from my Samsung device
Original message
From: "Michael D. Setzer II"
Date: 14/01/2017 07:57 (GMT+00:00)
To: Tanstaafl , users@global.libreoffice.org, Remy
Gaut
At 15:05 13/01/2017 -0500, Charles Marcus wrote:
Ok, this is really driving me nuts...
Given:
=MONTH(NOW())
results in the number of the current month (1, for January) I want
to simply translate this to the monthname, so I used:
=TEXT(MONTH(NOW()),"MMM")
this almost gives me what I want, but i
14.01.2017 u 08:55, Michael D. Setzer II je napisao/la:
Think the issue is that with "MMM", it treats the number as a date value
instead of as being a month, so that 1 would result in December, and 2-12
result in January.
So, the text option with month() doesn't seem to work at all, since the
