MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Return the name of the month, not the number?


Posted by Ben H on September 01, 2000 3:05 AM

This is a pretty simple one I guess, but the way I'm
doing it is by using Select Case in a function.

I'm wanting to return the current month's name instead
of the number (eg "July" instead of 7). There must be
a better way!?

Ben


Posted by David on September 01, 0100 3:21 AM


=TEXT(A1,"mmmm")


or

Range("A1").Select
Selection.NumberFormat = "mmmm"


or just format as mmmm

Posted by thomas venn on September 01, 0100 1:33 PM

=TEXT((A1),"mmmm")

cheers,

thomas