Forum Discussion
Need capital letters in DDMMMYY date formats.
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"))
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"))
A slightly shorter formula:
=UPPER(TEXT(A4,"ddmmmyy"))
Slightly shorter and a lot more elegant (AKA efficient). Well done. I tried something like that, but obviously not exactly...which is why I ended with what I did.
