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!?


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



Selection.NumberFormat = "mmmm"

or just format as mmmm

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