Display Month (MMMM) in uppercase

[ssmith]

When I display the month via MMMM, it returns the month as January,
Feburary.....
I would like it to be displayed as JANUARY, FEBURARY. Any thoughts?

 

[JE McGimpsey]

When I display the month via MMMM, it returns the month as January,
Feburary.....
I would like it to be displayed as JANUARY, FEBURARY. Any thoughts?

Unfortunately the only way I know to do it in place is to use VBA to
turn the date into a text string - which then renders it useless for
many functions.

If your date is calculated, or you can use a helper column, put the date
in the helper column and use

=UPPER(TEXT(A1,"dd mmmm yyyy"))

However, in general, I don't recommend using all caps anywhere...