Thread: =Text(n,"mmm") always returns "Jan" when n=1..12
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default =Text(n,"mmm") always returns "Jan" when n=1..12
n has to be a complete date value (yeae, month, day).
Try
=Text(date(2009,n,1),"mmm")
Regards,
Stefi

€žBlaze-Of-Glory€ť ezt Ă*rta:

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