Thread: =Text(n,"mmm") always returns "Jan" when n=1..12
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blaze-Of-Glory[_2_] Blaze-Of-Glory[_2_] is offline
external usenet poster
  
Posts: 1
Default =Text(n,"mmm") always returns "Jan" when n=1..12
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
Reply With QuoteReply With Quote