Thread: Cell formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Cell formatting
camp732 wrote:
I have this formula =MONTH(J8) in the cell but it is returning the # for the
month. How do I format it to return the month spelled out?

=TEXT(J8,"mmm")

=TEXT(J8,"mmmm")
Reply With QuoteReply With Quote