https://bugs.documentfoundation.org/show_bug.cgi?id=158694

Mike Kaganski <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #2 from Mike Kaganski <[email protected]> ---
MMMM format code in TEXT function expects that the number that is being
formatted is a *date* (i.e., a number of days since the date defined at
Options->Calc->Calculate, by default 1899-12-30).

But you pass there a number returned by MONTH function, i.e. an integer between
1 and 12.

Your formula should be

=TEXT(cell-id,"MMMM")

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to