Forum Discussion
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"))
This could be made more elegant, but here's a formula that will convert a standard Excel date to text.
=TEXT(DAY(A4),"0")&CHOOSE(MONTH(A4),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC")&TEXT(YEAR(A4),"0")As it's done here
See attached
