View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default extract the month

Try
=TEXT(G2,"mmmm")

or
Custom format that to mmmm

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


"Jim" wrote:

Hello,

I'm using the following to extract the month from a date: =MONTH(G2). I
can't seem to figure out how to get it to show the actual month (August)
instead of the numbered month (8).

Can you help?
Thanks