Date in Caps

L

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
 
D

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.
 
Top