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

0 votes

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
Oct 10, 2022 in Others by Kithuzzz
• 38,010 points
814 views

1 answer to this question.

0 votes

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"))

enter image description here

answered Oct 10, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
1,364 views
0 votes
1 answer

How to subtract date only format "mm/dd" in excel?

I suppose Excel has handled December 21 ...READ MORE

answered Dec 25, 2022 in Others by narikkadan
• 63,700 points
486 views
0 votes
1 answer

count() parameter must be an array or an object that implements countable in laravel

You will have to make one change ...READ MORE

answered Feb 10, 2022 in Others by Rahul
• 9,670 points
6,203 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,707 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,557 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
757 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,628 views
0 votes
1 answer

Rich text format (with formatting tags) in Excel to unformatted text

This function ought to be helpful if ...READ MORE

answered Oct 20, 2022 in Others by narikkadan
• 63,700 points
1,462 views
0 votes
1 answer

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,700 points
12,813 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP