Modifying MONTH() to return names of months

[dkn2101]

Is there a way to modify the MONTH() function to return names of months? For example, I have a cell, B5, with 8/16/2011.

Currently I can do =MONTH(B5) to return "8"

Is there a way to modify it so it would be: =MONTH(B5) --> "August" ...?

Any help would be greatly appreciated.

 

[Jonmo1]

Try

=TEXT(B5,"mmmm")

 

[njimack]

=TEXT(B5,"mmmm")

 

[dkn2101]

Ah ... thanks a bunch. I forgot about this function.

 

[Scott Huish]

If it's just for display, you can also do it without the function:

=B5

and custom format the cell as mmmm