View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default =Text(n,"mmm") always returns "Jan" when n=1..12

Try
=TEXT(date(year(today()),n,1),"mmm")

If this post helps click Yes
---------------
Jacob Skaria


"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