Thread: month name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default month name
=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1
=TEXT(A1,"mmmm") if you've got the date in A1
--
David Biddulph


"pat67" wrote in message
...
There is a function to show the number of the 1-12. Is there a way to
show the name?


Reply With QuoteReply With Quote