Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract the month
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract the month
Jim;456812 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 Hello Jim, You can use TEXT function, i.e. =TEXT(G2,"mmmm") -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126439 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract the month
Maybe you could use this instead: =TEXT(G2,"mmm")
which will directly extract the month from the date in G2 as text, eg: Aug aha? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Jim" wrote: 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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract month from date | Excel Discussion (Misc queries) | |||
Extract Month | Excel Discussion (Misc queries) | |||
extract the month of a date | Excel Discussion (Misc queries) | |||
How do I extract just the month | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) |