Excel formula to display months (numbers) in words

easier than a custom function:

First solution: modify the cell format
Enter a custom format "mmmm" which will display a date field
as a month in words.
Right-click on the cell > Format Cells > Custom > Type "mmmm" in the Type field.
Note: The cell retains the same value, only the display has changed.

Second solution: convert the date field to text
The TEXT function allows you to convert a numeric field into a text field while respecting a specified format.
You can also convert a date field into a text field.
In your case, you can write in B4 for example:
=TEXT(A4,"mmmm")
This time B4 contains indeed a text and no longer a date.

Hi forum

With the CHOOSE function

=IF(A4="","",CHOOSE(MONTH(A4),"January","February","March","April","May","June","July","August","September","October","November","December"))

Mytå
--
Thank you for responding to your question, we are not robots...
Installed versions [MsProject 2003(EN), Excel 2003-2007(EN)]

=TEXT(B9;"dd mmmm yyyy")