Forum Discussion
Solved
Need capital letters in DDMMMYY date formats.
In all aeronautical matters as well as in all planning travel, dates are crucial. Information regarding flights use a DDMMMYY format, with capital letters. Air Reservation systems only handle capit...
Excel does not provide a way to display month names in upper case in a number format.
So you'll have to use one column to enter the "real" dates, to be used in calculations, and another column to display the dates the way you want, as text. Just like in the reply by mathetes
A slightly shorter formula:
=UPPER(TEXT(A4,"ddmmmyy"))
AntonioPonce AFAIK you would need to use a TEXT() function to enforce UPPER() which has already been suggested however you could try in addition to your present custom formatting change the font for that cell/range to a font that allows only UPPER case letters. Watch below:
- Fonts that does the trick ensuring the dates are not formatted as text and retains the dates as numbers are Stencil, Perpetua Titling MT, Engravers MT and Felix Titling!!