=Text(n,"mmm") always returns "Jan" when n=1..12
To the best of my knowledge, Excel (at the worksheet level) never had a
MonthName function; however, there is one at the VBA level. Perhaps you had
UDF (user defined function) that provided this functionality. The function
would have looked like this...
Function MonthName(MonthNumber As Long) As String
MonthName = VBA.MonthName(MonthNumber)
End Function
and it would have been installed in a Module.
--
Rick (MVP - Excel)
"Blaze-Of-Glory" wrote in message
...
Thanks to all those who replied - It's not at all clear from the help for
text() that the date format expects epoch time. I am still missing the
Monthname() formula I used to have in previous versions of excel.
"Blaze-Of-Glory" wrote:
Excel 2007 - Why doesn't this work? Being forced to use VLookup and make
a
month table each time I want to convert a month number to a month nme
|