Date in Caps

[Lynn]

Is there a custom format I can use to have Excel display
the month name in all caps? Even if I type in caps it
displays in Title case Eg. MAY 17 instead of May 17

 

[Dave Peterson]

You could treat it as text and start with a leading apostrophe:

'MAY 17

But then it's text.

Maybe a helper cell =upper(text(a1,"mmm dd"))

Hide the original cell, but use that in any further calculations.