Excel formatting DD-MMM-YYYY must be in this format

Question

I've got some numbers below. See the list below. I require Excel to enter these dates exactly in this format: DD-MMM-YYYY. MMM must also be written in all caps. JUN as opposed to Jun Additionally, for DD, it must be 03 and cannot be 3. I am not given this choice by the Excel date formats. It appears to me that there may be a custom formatting choice. How exactly do I format in this format? I'll explore the bespoke formats to see if I can solve this.

Have

EFFECTIVE_START_DATE
3-Jun-2019
3-Jun-2019

Want

EFFECTIVE_START_DATE
03-JUN-2019
03-JUN-2019

Answer 1

There is no special structure for months that are capitalized.

If the existing cell can be referenced, use TEXT to style the date as desired and then UPPER to change it to upper case.

=UPPER(TEXT(A2,"dd-mmm-yyyy"))