Thread: Function to return a month name from a number (1-12) that is not a
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_2_] Roger Govier[_2_] is offline
external usenet poster
  
Posts: 57
Default Function to return a month name from a number (1-12) that is not a
Another way

Format the cell as FormatCellsNumberCustom mmm
=A1*30


--
Regards
Roger Govier



"Chuck M" wrote in message
...
Hi,
I need to return the month name (Jan, Feb, etc.) from a number (1-12).
However the number is not a date. I know can set up a range containing the
month names and do a vlookup but I was wondering if there is a more
compact
and effecient way to do this with a function.

--
TIA
Chuck M.


Reply With QuoteReply With Quote