View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cygnus
 
Posts: n/a
Default how to convert single digit to month name


I can't for the life of me figure out how to convert a number in a cell
which has a value of 1 to 12 into a month name.
E.g. If A1=1 then B1 should = "January".

The date functions don't seem to help unless you have a whole date E.g.
DD/MM/YYYY.

Is there a native function I can use, or am I stuck doing a vlookup on
a list I specify elsewhere?


--
cygnus